Date to number- Please Help!

jroxit · June 9th, 2008, 09:48 AM

This is kind of crazy but here goes. I need to first take a timestamp, then break it into two variables: date and time. But when I write it to my database, I want to write both variables as numbers with no formatting.

For example: 06/06/2008 1:23 PM
would become:
060608 and 1323

Please help. If it can be done, I know someone here knows how....you guys are my heroes!

Old Pedant · June 9th, 2008, 01:10 PM

Trivial:

Code:

dt = ...some date and time variable or value ...

dayNumber = Month(dt) * 10000 + Day(dt) * 100 + (Year(dt) MOD 100)
timeNumber = Hour(dt) * 100 + Minute(dt)

But I would like to comment that your "dayNumber" is now a value that you can *NOT* compare!

That is, you can't do
If dayNumber1 > dayNumber2 Then
and have it do anything meaningful.

You'd be a lot better off using the format YYYYMMDD if you want to be able to compare the resultant numbers in any meaningful way.