View Full Version : Format is all wrong


arage
03-30-2001, 05:42 PM
I enter ##/##/## as the format property for some date fields on my form, and it ends up reverting to something like this #\/#\/# instead and when I try to enter dates in the fields they look like this 101/0/1
I would love to hear someone’s opinion on what is going on here. Please advise.

gzuroweste
04-01-2001, 01:45 PM
The ## are used as place holders. Try using the format 00/00/00 instead. It should return, ex: 04/01/01 as 4/1/01.

If you need the leading zeros try "mm/dd/yy"

Also make sure that the field on your Table is setup as a date, and not a text.