Share via

Date/Time Input Mask

Anonymous
2014-06-17T23:17:47+00:00

What is the input mask for date AND time in a field?  I'd like for staff to just put in numbers without having to worry about the slashes and colons, etc.

I did not find the wizard particularly helpful.

Thank you.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-06-17T23:45:30+00:00

    Hmm, well, would that be...

    For date MM/DD/YYYY use 99/99/0000;0;_

    For time 00:00 AM/PM use 99:00\ >LL;0;_ Side note: For time they will have to enter AM or PM.

    Was this answer helpful?

    0 comments