Num to date

[nareshthavidishetty]

How to covert a number in date format

Num= 1141213

[Anonymous]

Try this,

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

Regards,

Leni Balakrishnan

[rajeshforqlikvi]

=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]

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]

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

[nareshthavidishetty]

1141213 is an application submission date.

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

[Anonymous]

What result are you hoping for ?

[maxgro]

post some expected output, at least one

number          date

1141213        ??/??/??

.....                    ..... 

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