Convert Date to General number

[simon4amiee]

Is it possible to easily convert 02/02/2015 15:30:00 to 201502021530 in a query?

 

[CJ_London]

use the format command

format(mydate,"yyyymmddhhnn")

which is text
and to convert this to a number

surround with clng

clng(format(mydate,"yyyymmddhhnn"))

 

[spikepl]

Errr that number is beyond the range of Long.

 

[CJ_London]

OK - cdbl then. my bad

Although for all intents and purposes it will sort the same way as text as a number and I can't see you wanting to add or divide it so the conversion to number is probably academic anyway

 

[spikepl]

The date already is a number - one of type Double. What is the purpose of this suggested conversion?