topic Re: date in QlikView

date

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have field called date and the format is shown in the below screenshot.

if you look at the date for 16-Oct it is repeated three times because of the different time seconds ..

I am trying to get only unique date as 16- October by writing the below script .

Date#(Date(date,'MM/DD/YYYY:hh:mm:ss'),'MM-dd-yyyy') as date

but still i am getting the same thing ..how can i make it one date ....

Thanks in advance

smilingjohn — Wed, 17 Oct 2018 04:56:21 GMT

This is simple

i got it ..i need to write it like this

date#(date(date ),'DD.MM.YYYY') as date ,

Anil_Babu_Samineni — Wed, 17 Oct 2018 04:56:51 GMT

Try this?

Date(Date#(date,'MM/DD/YYYY:hh:mm:ss'),'DD-MMM')

Date(Floor(Date#(date,'MM/DD/YYYY:hh:mm:ss')),'DD-MM-YYYY')

arvind_patil — Wed, 17 Oct 2018 04:56:58 GMT

Hi John,

Try Below :

Date(Floor(date Field)) as Date

Thanks,

Arvind Patil