I am wanting to convert the current system date and time to a serial value.



Example - Say the Now() function returns "3/13/2007 4:55 PM", the serial equivelent is 56381280.

What I can't figure out is how to make this conversion in Access. In Excel you can format a cell as serial but I can't find similar in Access.