=Date() Formatting Challenge

  • Thread starter Thread starter XYZ-Man
  • Start date Start date
X

XYZ-Man

One of my tables contains a text field, which is intended to record a
date is such format as 01/04/2005. For this text field I used an input
mask 99/99/0000;0;_ which worked well.
However when I tried to automate the field in a form with a drop-down
list, which would automatically look up the system date and fill in
the data in the field by using the =Date(), I ran into a problem as
the =Date() function seems to ommit the 0's. So for example for
today's date it would fill in 1/9/2005 instead of 01/09/2005.
Is there a way around this by forcing the 0's to appear?

I can't change the text field into a date field because for some
reason, I ran into issues with date fields and relationships working
together.

I am using Access 2003. Any suggestions are appreciated.

Thank you,
Rob
 
Why can't you just make it a date field with the default value =Date(), and
the format mm/dd/yyyy? How does that create a problem with relationships?
 
Thank you, that worked. I really wonder why I could find this answer
in the help file anywhere. Oh, well, thank God for you guys and this
newsgroup!..

Thanks again!
 
Back
Top