Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All
I have a field name called Date and the date format in which is like below
How do i convert this date
11/30/2016 11:59 PM MST
into "DD-MM-YYY"(30-11-2016)
Regards
May be like this:
Date(Date#(SubField(Date, ' ', 1), 'MM/DD/YYYY'), 'DD-MM-YYYY') as Date
May be like this:
Date(Date#(SubField(Date, ' ', 1), 'MM/DD/YYYY'), 'DD-MM-YYYY') as Date