How to get date from integer format

[#1]

HI

1308731652

1283938205

is the data in the date feild,

I wanted to convert to datetime.

Thanks in Adv,

Venkatesh

[vijay_iitkgp]

Hi,

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

[#3]

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.

[#4]

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

[hic · Accepted solution]

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)