Custom date format

[bacardi451]

Hi,
I have created a custom date and time format (MM/DD/YYYY HHMM) I am trying to get the default value to put the date and time when someone puts in a new record.
I have tried the Now() in the default value and it gives me the date and time but the only problem is that it gives me time in HH:MM:SS and AM/PM. Is ther a way to have it just the HHMM and military only.

Thank you in advance
Al

I apoligize for the inconvience I need the date and time together example mm/dd/yyyy - hhmm. (10/11/2002 - 1425)

thanks
Al

 

[Dave Eyley]

I've used Time() and selected Short Time as a Format. Try that.

Dave E

 

[jtownraven]

the regional setting

in order for access to recognize your custom format, you have to have it set in the regional setting (in the control panel.) if your custom format does not comply with any of the listed formats they have, access will ignore it. but you can customize it in the regional settings and pick it from there in access.

 

[Pat Hartman]

Access stores dates internally as a double-precision (floating-point) number with the integer portion representing the number of days since Dec 30, 1899 and the decimal portion representing the number of miliseconds since midnight.

The regional date format set in the windows control panel will apply whenever no specific format has been set for an Access date/time field. You don't say where you set the format, but it will only apply there. For example, if you set the format on the date/time field of a form, that would NOT affect the format of the same field in a report. If you set the format at the table level, that would affect all FUTURE references of that field in queries/forms/reports but NOT any existing ones.