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.