Convert date to it's numerical equivalent in a query

[accessmatt]

How can I convert a date format to it's numerical equivalent inside of a query? For instance, 1/1/2014 to be 41640.

Thanks

[JoeM]

Assuming that your Date field is stored as Date and not Text, one way is to use one of the numeric conversion functions, like CDbl:

CDbl([DateField])

[June7]

Be aware, all the number conversion functions will error on Null and alpha/empty string. So if there is possibility field is Null, need to handle.

CDbl(Nz([DateField]))