How to use Input mask for general date with milliseconds added

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • neelsfer
    Contributor
    • Oct 2010
    • 547

    How to use Input mask for general date with milliseconds added

    I am having a problem creating this input mask wizard for the following general date format:

    Code:
    12/11/2011 09:33:46.240
    the general date i use needs to be changed:
    Code:
    00/00/0000\ 00:00:00\ >\ LL;0;#
    please assist
    thx
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    I think that you would need to set the Data Type of the Field to TEXT, then try the following Input Mask:
    Code:
    00/00/0000\ 00:00:00.000;0;#
    P.S. - By setting the Field to TEXT, it would make it very easy for a User to enter Invalid Dates and/or Times.

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32661

      #3
      Code:
      00/00/0000\ 00:00:00.000\ >LL;0;#
      seems to work ok. I used an unbound control so I don't think the type of any underlying field is important.

      PS. Unlike your example, the data would need AM or PM appended.

      Comment

      Working...