Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like:
Date(Floor(Date#(DateField, 'M/D/YYYY h:m')),'DD/MM/YYYY')
hi,
you can also do like below
date(floor(num(datefield)),'DD/MM/YYYY')
$@M.
That worked. Thanks