Entering and storing dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a date to store in a record as Sunday, March 1, 2006, but the person
doing the data entry can enter the date as 3/1/06. Can someone walk me
through this?
 
Why? DateTime fields actually store a number that gets converted to a date.

If you want to DISPLAY the date as you said, then you use the format
function or the format property of the controls. With the format function
that is.

Format(TheDate,"Long Date") or
Format(TheDate,"dddd, mmmm d, yyyy")

With control's format property, just enter the string with the quotes.
 
Back
Top