Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to convert the below date format into "DD-MM-YYYY"
2022-05-19 12:07:25.0000000
Thanks,...
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')
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')