Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I convert date '01 Mar 2016 03:18:20' to 01/03/2016 ?
Date(Date#(Left('01 Mar 2016 03:18:20',11),'DD MMM YYYY'),'DD/MM/YYYY')
Date(Date#(Left('01 Mar 2016 03:18:20',11),'DD MMM YYYY'),'DD/MM/YYYY')
Date(Floor(Date#('01 Mar 2016 03:18:20','DD MMM YYYY hh:mm:ss')),'DD/MM/YYYY')
Hi,
If your timestamp is already loaded as dual value (text with underlying number) and 'DD/MM/YYYY' is your default DateFormat then it could be as easy as
DayName(YourTimestampfield)
So it depends on your application.
regards
Marco
HI,
You can try
Date(Date#(Left('01 Mar 2016 03:18:20',11),'DD MMM YYYY'),'DD/MM/YYYY')
OR
Date(Floor(TimeStamp#('01 Mar 2016 03:18:20','DD MMM YYYY hh:mm:ss')),'DD/MM/YYYY')
Hope this helps you.
Regards,
Jagan.