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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Property sheet data missing also syntax 0
Excel Message box called if 1 of 3 options is entered. 4
Count distinct number of days 4
Appending individual dates using a date range 1
Enter dates in short form, but store them in Long Date format 2
Excel Is this possible?? 3
News from Mobile World Congress 2018 0
Finding Specific days in the year 2

Back
Top