Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a date field and I want to change the format from 'YYYY-MM-DD HH:mm:ss' to 'DD-MM-YYYY', like:
2020-09-23 00:00:00 to 23.09.2020
Hello,
Please try below expression,hope this helps you!!
date(date#([DateField],'YYYY-MM-DD HH:mm:ss'),'DD-MM-YYYY')
or
date(date#([DateField],'YYYY-MM-DD HH:mm:ss'),'DD.MM.YYYY')
Regards,
Bhavya
@jisephcirspy If your date field is a proper date type (number at the back) field, you could simply use date(), like:
Date(DateField,'DD-MM-YYYY')
If it is a text field, you have to parse the data using parsing functions like date#() and wrap it with date(), like:
Date(Date#(DateField, 'YYYY-MM-DD hh:mm:ss' ),'DD-MM-YYYY')
You can also think of truncating the unnecessary timestamp using floor(), like:
Date(Floor(DateField),'DD-MM-YYYY')
Or,
Date(Floor(Date#(DateField, 'YYYY-MM-DD hh:mm:ss' )),'DD-MM-YYYY')
If you have more than one time registred per day you will need to use Floor as @tresesco suggests. Take alook at the image and script below and you will notice that not using floor will give you multiple instances of field values that looks the same, but have different undelying numeric values.
LOAD
date(floor(timestamp#("My timestamp",'YYYY-MM-DD HH:mm:ss')),'DD-MM-YYYY') as "My date",
date(timestamp#("My timestamp",'YYYY-MM-DD HH:mm:ss'),'DD-MM-YYYY') as "My date (not floored)",
"My timestamp"
inline [
My timestamp
2020-09-23 09:52:00
2020-09-23 13:52:22
2020-09-22 09:52:00
2020-09-21 03:02:30
2020-09-21 03:01:00
2020-09-21 13:09:00
];