topic How to get date from integer format in QlikView

How to get date from integer format

Mon, 16 Jan 2012 06:54:04 GMT

1308731652

1283938205

is the data in the date feild,

I wanted to convert to datetime.

Thanks in Adv,

Venkatesh

How to get date from integer format

vijay_iitkgp — Mon, 16 Jan 2012 06:59:28 GMT

Hi,

Ii does not looks correct numeric date . correct date should be 5 digit number or 5 digit number with decimal .

Re: How to get date from integer format

Mon, 16 Jan 2012 07:42:41 GMT

Hi Venkatesh,

I Agree with Vijay.As per my understanding, the value which u have provided is incorrect value. I've attached one sample application with value which is showing the correct date and time by using timestamp and date function. please go-through the attachment file. Forgive me if i couldn't understood properly r if u find any mistakes in my reply.

Warm Regards,

Arun Prasadh.N.

How to get date from integer format

Mon, 16 Jan 2012 08:36:42 GMT

First convert this integer date field in correct data field like 5 digit number and then apply DATE#,DATE FUNCTION to get a final date field.FLOOR IS another option available to filter it.

Regards,

Dushyant

How to get date from integer format

hic — Mon, 16 Jan 2012 11:58:25 GMT

This looks like UNIX time to me, i.e. the number of seconds elapsed since midnight Thursday, January 1, 1970, UTC.

If it is, you could convert this number to a QlikView date by using
Date(MakeDate(1970,01,01) + YourDate / 24 / 60 / 60)