I have a String with this value, this is the only value in the field:
‘27/05/2024 17:10:03’
Date in dd/MM/yyyy format and clock in 24h format.
I used this code to parse the field:
“parseDate({data_att}, ‘dd/MM/yyyy HH:mm:ss’)”
And when I show this field in QS I had this return, it skipped the hours:
‘27/05/2024’
I’ve already tried to format in Custom formatting, but didn’t work.
Is there something I’m missing in parseDate or something I need to do before this one?
Hi,
This will be solved by the given documentation. Just give the formate as your “Date source type”
Regards,
Naveed Ali
Like I said in this part:
I used this code to parse the field:
“parseDate({data_att}, ‘dd/MM/yyyy HH:mm:ss’)”
I’ve already tried to use parseDate and the giving the format, but it didn’t work.
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)