Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following value - 2016-08-31 08:32:48:000 + 01:00
What is the best way to extract the date, I tried FLOOR and Date Function and it returns nothing.
I know I can try LEFT(DateTimeCreated,10) and that will return the date and I can then convert to DD/MM/YYYY instead of YYYY-MM-DD.
Any better methods to do this?
Thanks
Alan
If you use left() - a string function, it might not give you a real date (number at the back-end). You should rather use parsing function date#() alongwith it like and then format using date():
Date(Date#(LEFT(DateTimeCreated,10), 'YYYY-MM-DD'), 'DD/MM/YYYY ')
If you use left() - a string function, it might not give you a real date (number at the back-end). You should rather use parsing function date#() alongwith it like and then format using date():
Date(Date#(LEFT(DateTimeCreated,10), 'YYYY-MM-DD'), 'DD/MM/YYYY ')
Thanks Tresesco