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.

[Anonymous]

Try something like this

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

[Anonymous]

Or maybe even this :

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

[agomes1971]

Hi,

see this:

Num(Date#(Field, 'MM/DD/YYYY')) AS NumericDate

Regards

André Gomes

[its_anandrjs]

Try in place of the NUM with Date#

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

Regards

Anand

[shree909]

Try this

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

[its_anandrjs]

Or you can try

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

Regards

Anand

[ashfaq_haseeb]

Hi,

This should work

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

Regards

ASHFAQ

[rwunderlich · Accepted solution]

If you really want the *numeric* value to be 20141112, then I think it would be done like this:

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

-Rob

[#10]

Thanks Rob.It is always a pleasure to see you here.Yes I wanted to have a numeric value because at the end I am going to comapre this date converted numeric vaule with another Numeric field.Thanks again for your help.