Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
date as yyyymmdd
- Thread starter Mattb7
- Start date
Matt,
Check out the help for "format". Much of the time you'll be able to answer questions like this by looking through the help files.
Definitely store it as a date, if that's what it is. When you display your value, eitehr on a form or on a report, just do this:
format([MyDateField], "yyyymmd"
You will have to do it everywhere it's displayed, but it's still a better way to go about it.
Jeremy =============
Jeremy Wallace AlphaBet City Dataworks See the Developers' section for some helpful fundamentals.
See thread181-473997 for information on how to get the best responses possible here at Tek-Tips.
Check out the help for "format". Much of the time you'll be able to answer questions like this by looking through the help files.
Definitely store it as a date, if that's what it is. When you display your value, eitehr on a form or on a report, just do this:
format([MyDateField], "yyyymmd"
You will have to do it everywhere it's displayed, but it's still a better way to go about it.
Jeremy =============
Jeremy Wallace AlphaBet City Dataworks See the Developers' section for some helpful fundamentals.
See thread181-473997 for information on how to get the best responses possible here at Tek-Tips.
- Status
Similar threads
- Locked
- Question
- Locked
- Question