enter only date in textbox
- Thread starter azoz124
- Start date
stopher
AWF VIP
- Local time
- Today, 14:25
- Joined
- Feb 1, 2006
- Messages
- 2,395
Welcome to the forum.
Dates are stored in Access as a decimal number (the whole number part being the date and the fraction being the time). So regardless of how you ask the user to enter the date, it will still get stored as a decimal (assuming you are using the date datatype). So regardles of whether the user enters 2008/6/24 or 24/6/2008, the date will be accepted and stored as a decimal number (39623 in this case)
However, Access has some good tools for displaying the date how you want e.g. using the formating options or the Format function.
Why did feel that you needed to store in this format?
Chris
Dates are stored in Access as a decimal number (the whole number part being the date and the fraction being the time). So regardless of how you ask the user to enter the date, it will still get stored as a decimal (assuming you are using the date datatype). So regardles of whether the user enters 2008/6/24 or 24/6/2008, the date will be accepted and stored as a decimal number (39623 in this case)
However, Access has some good tools for displaying the date how you want e.g. using the formating options or the Format function.
Why did feel that you needed to store in this format?
Chris
