How to change date format to number format ??

[skr002244]

how to change

22/10/2015

11/11/2015

25/12/2015

into number format ?

[#2]

Hi ,

Try this

num('22/10/2015')

Thanks

Harsha

[Anonymous · Accepted solution]

Hi,

Num(date_field) gives u the answer

HTH.

[avinashelite]

Hi Santha,

Use Date#(date_field) to convert date to other format.

To format date field use Date() function.

[Anonymous]

Hi Try like this

=Num(Today())  gives the number as 42009

Like wise use in u r requirement

[skr002244]

if 17/9/2015 is in char format then how to change it ?

[Anonymous]

Use num(date(date#('17/9/2015','dd/mm/yyyy')))

[skr002244]

if i want to have multiple date format like d/m/yyyy ???

[jagan]

Hi,

Then try like this using Alt()

=Alt(Date#(DateField, 'd/M/yyyy'), Date#(DateField, 'M/d/yyyy'),Date#(DateField, 'd/MMM/yyyy'), ...............

)

Regards,

Jagan.