Hi,
I have created calculated field called start_datetime_string that creates a string while concatenating Date with time:
concat(left(toString(Date),10),’ ‘,left({start_time},locate({start_time},’:‘,1)),right({start_time},2),’:00’)
Based on this new field I have created another calculated field, in order to convert the string to datetime value:
parseDate({start_datetime_string},‘yyyy-MM-dd HH:mm:ss’)
Why the second calculated filed present only the date without the time?
Hi @Annab
did you check the formatting in the table for the second field?
BR
@Annab were you able to find a solution or a workaround or are you still facing this issue?
A few suggestions: 1) I have found the “Format” option in the dataset menu to be somewhat unreliable unless you go all the way into the editor menu and manually update the format. 2) You could try wrapping your parseDate funtion in fromatDate
@duncan It didn’t work for me, so I used 2 fields in reporting, one for sorting and calculation - in datetime format and another one for visualization - in string format
