date Format

[gbanks]

Looking for a special date format. I would like the user when the enter the date into a date field in my db to enter the date in this format 07302002 Is there a format I can put into a control on a form or on the table's format field so this will be the only format excepted. Thanks...

 

[antomack]

Check the help file under
Input Masks

 

[raskew]

Whoa!

What could possibly be gained by showing short-date 07/30/02 (30-Jul-2002) in an unintelligible format (not recognized as a date by any programming language), i.e., 07302002? How does that work and what are the potential benefits?

Why would we ask our operators to input in such a cryptic manner? If there's a reason, in a report or form, to display the 07302002 format, we could do it with this:

mydate = #07/30/02#
? mydate
7/30/02
? format(month(myDate), "00") & format(day(myDate), "00") & format(year(myDate), "0000")
07302002

…but to lay that burden on the operators is an invitation for disaster.

Please review your logic.