Convert date to number

[JAD001]

Trying to convert a date in my query to a number. What function will convert 6/17/2015 to 42172? Tried datevalue dateserial

 

[pr2-eugin]

CDbl is the function.

? CDbl(Date())
 42173 
? CDbl(Now())
 42173.6818402778

 

[CJ_London]

try clng

clng(date())

 

[JAD001]

Thanks CDbl and clng both worked. Have to read up on them and why I could not find them.
Thanks again!