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.