convert

[smilingjohn]

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

[sunny_talwar · Accepted solution]

May be like this:

Date(Date#(SubField(Date, ' ', 1), 'MM/DD/YYYY'), 'DD-MM-YYYY') as Date