date and time

[Ruth]

Hi there

I want the date and time to be entered and displayed as:

DD-MON-YYYY 24:00

12-OCT-2008 13:50

with the 24 hour clock rather than stating AM and PM.

How do I do this?

 

[Jerry Whittle]

At the table or form design make the Input Mask like below:

00\->LLL\-0000\ 00:00;0;_

At the table, form, or report design, make the format:

dd-mmm-yyyy hh:nn

One problem is that the format will display the month as Oct and not OCT.

 

[Ruth]

That is perfect-- thank-you!
--
Thank-you!
Ruth

At the table or form design make the Input Mask like below:

00\->LLL\-0000\ 00:00;0;_

At the table, form, or report design, make the format:

dd-mmm-yyyy hh:nn

One problem is that the format will display the month as Oct and not OCT.