topic Re: Num to date in QlikView

Num to date

nareshthavidishetty — Wed, 13 Jan 2016 11:36:02 GMT

How to covert a number in date format

Num= 1141213

Re: Num to date

Anonymous — Wed, 13 Jan 2016 11:41:33 GMT

Try this,

=Date('1141213','MM/dd/yyyy')

Regards,

Leni Balakrishnan

Re: Num to date

rajeshforqlikvi — Wed, 13 Jan 2016 11:45:42 GMT

=Date(1141213, 'DD/MM/YY')

Re: Num to date

sunny_talwar — Wed, 13 Jan 2016 11:47:24 GMT

May be this:

Date(NumberField) as Date

and if you want it to be of specific format then this:

Date(NumberField, 'YourFormatHere') as Date -> Example: Date(NumberField, 'MM/DD/YYYY') as Date

What tresesco said makes sense.

Re: Num to date

tresB — Wed, 13 Jan 2016 11:48:22 GMT

Usually, Date(number) would give you a date. But here the question is - is your number 1141213 having a special meaning? What is the expected output? How do you interpret that?

Re: Num to date

sunny_talwar — Wed, 13 Jan 2016 11:50:22 GMT

Good point . Didn't even look at what the number was

Re: Num to date

Anonymous — Wed, 13 Jan 2016 11:54:44 GMT

Doesn't look like Unix Epoch Date either, unless it is analyzing data from the 1970's.

Re: Num to date

nareshthavidishetty — Wed, 13 Jan 2016 12:07:30 GMT

1141213 is an application submission date.

I have used =Date('1141213','MM/dd/yyyy') but am getting the result as 2/7/5076

Re: Num to date

Anonymous — Wed, 13 Jan 2016 12:09:26 GMT

What result are you hoping for ?

Re: Num to date

maxgro — Wed, 13 Jan 2016 12:14:54 GMT

post some expected output, at least one

number date

1141213 ??/??/??

..... .....

or should we continue to guess (unix epoch, MM/DD/YYYY, ....) ?