Date conversion to Number

[#1]

I need to convert a date field into Numeric.

Num(Date ( 2014/11/12 , 'YYYYMMDD' )  )

output expecting:20141112

The num function giving me the result but not the way I was expecting.Any help on this would be great.

[its_anandrjs]

Hi,

Yes Rob is right

If want to exactly number then use it

=Date(Num(Date# ( '2014/11/12' , 'YYYY/MM/DD' ) ),'YYYYMMDD')

If want exactly Date then write like

=Date (Date#('2014/11/12' , 'YYYY/MM/DD' ) ,'YYYYMMDD')

Regards

Anand