Date Conversion

[krish2459]

Hi ,

How to convert the below date format into "DD-MM-YYYY"

2022-05-19 12:07:25.0000000

Thanks,...

[justISO · Accepted solution]

Hi, if your date field is a string, you can try

=Date(Date#(left(date, 10),'YYYY-MM-DD'),'DD-MM-YYYY')

if it is timestamp

=date(floor(date), 'DD-MM-YYYY')