topic Re: Date Time to Date in QlikView

Date Time to Date

kevbrown — Thu, 29 Jan 2015 16:51:49 GMT

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

Re: Date Time to Date

MarcoWedel — Thu, 29 Jan 2015 16:55:48 GMT

DayName(Date)

Date(Floor(Date))

hope this helps

regards

Marco

Re: Date Time to Date

its_anandrjs — Thu, 29 Jan 2015 16:56:49 GMT

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

Re: Date Time to Date

kevbrown — Thu, 29 Jan 2015 17:00:17 GMT

Superb, thanks

Re: Date Time to Date

MarcoWedel — Thu, 29 Jan 2015 18:50:40 GMT

You're welcome

Regards

Marco