Changing field format in Access 2003
We have an Access data base that includes date of birth in the format mm/dd/yyyy.
For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record?
This would save us hours of work.
Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
January 28, 2009 8:23 PM
UPDATED:
January 28, 2009 11:09 PM
RELATED QUESTIONS
- Date fields in Microsoft Access 2007 when mail merged into a letter etc, become American. ie 5/18/2010 instead of 18/5/10
- Audit Question - *CHANGE access
- How do I convert a date in text format to a proper date with AS/400 Query
- Setting up administrative access in Windows 7
- How to remove specific lines from a text files using either vbs or bat.
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Is that field in Date/Time format or Text format?