Date format to DD/MM/YYYY

Jay-IRT — Thu, 11 Apr 2024 06:59:38 GMT

1083216:18:28 AM

How do I change the above format to DD/MM/YYYY ?

Re: Date format to DD/MM/YYYY

Vegar — Thu, 11 Apr 2024 07:01:52 GMT

What are you expecting to see with that timestamp?

Do you know from which source you are fetching it?

Re: Date format to DD/MM/YYYY

Vegar — Thu, 11 Apr 2024 07:27:49 GMT

If we can assume that this is a timestamp on the format

hh:mm:ss TT then we can use that in order to present it as a date in tree steps.

dayname(timestamp#( subfield('1083216:18:28 AM',' '), 'hh:mm:ss'))

1: subfield('1083216:18:28 AM',' ') picks out the timestamp excluding the AM/PM info. This part fill return '1083216:18:28'

2: timestamp#([...], 'hh:mm:ss') inerprets the string value as a timestamp in the 'hh:mm:ss' format (or in your case its more like 'hhhhhhh:mm:ss'. The output of this is now intepreted as a timestamp, but presented as it is written '1083216:18:28'

3: dayname([...]) converts the timestamp into a date value and presents it as a date according to your application's default pattern. This step returns a date, having DD/MM/YYYY as default formating returns 27/07/2023

3 (Alternative method) Date(Floor([...]), 'DD/MM/YYYY')

Re: Date format to DD/MM/YYYY

Jay-IRT — Thu, 11 Apr 2024 10:08:12 GMT

Thank you it worked for me !

topic Re: Date format to DD/MM/YYYY in App Development

Date format to DD/MM/YYYY

Re: Date format to DD/MM/YYYY

Re: Date format to DD/MM/YYYY

Re: Date format to DD/MM/YYYY