Date Time to Date

[kevbrown]

I have a field called Date which is a date time field. I would like a List Box based on this field but only want to show Date. Currently I'm guessing the date but dupplicated, I've tried changing the number format and Date(Date) but still get dupplicates

Kev

[MarcoWedel · Accepted solution]

DayName(Date)

or

Date(Floor(Date))

hope this helps

regards

Marco

[its_anandrjs]

Hi,

You can try with Date(DateTime,'MM/DD/YYYY')

Ex:-

LOAD Date(DateTime,'MM/DD/YYYY') AS DateOnly,*;

LOAD Timestamp#(DateTime,'MM/DD/YYYY hh:mm:ss TT') as DateTime;

Load * inline

[

DateTime

01/29/2015 10:24:11 PM

];

Regards

Anand

[kevbrown]

Superb, thanks

[MarcoWedel]

You're welcome

Regards

Marco