DATE FORMAT

[upaliwije]

Hi

In my data table date is recorded in the following way

17-May-2007 19:05:11

17-May-2007 19:07:36

17-May-2007 19:08:58

17-May-2007 19:09:38

17-May-2007 19:13:41

17-May-2007 19:23:46

I want to return the date without time as given below

17-May-2007

Pls help me to format this in my load script

[tresesco · Accepted solution]

Your date field seems to be coming as proper date. So, you don't have to use date#(), try simply:

Date(Floor(YourDate), 'DD-MMM-YYYY') as NewDate

[upaliwije]

Thanks all for your contribution