Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
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
Anonymous
Not applicable

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

Anonymous
Not applicable

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

Anonymous
Not applicable

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, ....) ?