Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Num to date

How to covert a number in date format

Num= 1141213

9 Replies
leni_balakrishn
Creator III
Creator III

Try this,

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

Regards,

Leni Balakrishnan

rajeshforqlikvi
Creator
Creator

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

sunny_talwar

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.

tresesco
MVP
MVP

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?

sunny_talwar

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

bill_markham
Champion III
Champion III

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

nareshthavidishetty
Creator III
Creator III
Author

1141213 is an application submission date.

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

bill_markham
Champion III
Champion III

What result are you hoping for ?

maxgro
MVP
MVP

post some expected output, at least one

number          date

1141213        ??/??/??

.....                    ..... 


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