topic Re: date format in QlikView

date format

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

Hi,

can any one please help me

I have date field with number format Timestamp.

first one is the original foramt second one is the converted format

In the Converted format i am getting the one date many times ideally its not correct.

Please help me to resolve.

I have used the below script

Date(Num(VIOLATION_DATE),'MM/DD/YYYY') as VIOLATION_DATE,

Thanks

kristof_j — Fri, 16 Sep 2016 06:52:10 GMT

and if you use

Date(VIOLATION_DATE) as VIOLATION_DATE?

Fri, 16 Sep 2016 06:56:09 GMT

Do this :

Date(floor(VIOLATION_DATE)) as NewDate

MindaugasBacius — Fri, 16 Sep 2016 07:00:10 GMT

Try this:

Date(Floor(OLD_VIOLATION_DATE),'MM/DD/YYYY')

It will Round the number to the integer and duplicates will disappear.

trdandamudi — Fri, 16 Sep 2016 07:00:35 GMT

May be as below:

Date(Num(Floor(VIOLATION_DATE)),'MM/DD/YYYY') as VIOLATION_DATE

Chanty4u — Fri, 16 Sep 2016 07:06:56 GMT

its working as below

aa:

LOAD * INLINE [

Date

40544

40544.010416667,

4054.09375

];

LOAD *

Date(Num(Floor(Date)),'MM/DD/YYYY') as VIOLATION_DATE

Resident aa;