Date Formats

[pooja_sn]

I have my data with a date column having dates in below format.

6/7/2016 9:51 or 6/17/2016 11:10 (M/D/YYYY h:m). How can I convert it to DD/MM/YYYY.

Floor() doesn't work for me in this case.

[tresesco · Accepted solution]

Try like:

Date(Floor(Date#(DateField, 'M/D/YYYY h:m')),'DD/MM/YYYY')

[mightyqlikers]

hi,

you can also do like below

date(floor(num(datefield)),'DD/MM/YYYY')

$@M.

[pooja_sn]

That worked. Thanks