Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to get date from integer format

HI

1308731652

1283938205

is the data in the date feild,

I wanted to convert to datetime.

Thanks in Adv,

Venkatesh

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

How to get date from integer format

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)

4 Replies
vijay_iitkgp
Valued Contributor

How to get date from integer format

Hi,

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

Not applicable

Re: How to get date from integer format

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.

Not applicable

How to get date from integer format

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

Highlighted
Employee
Employee

How to get date from integer format

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)

Community Browser