JustATheory
IS-IT--Management
Greetings,
I'm attempting to change a column from TEXT to a date format in a query. When I use Format([TEXT],"MM/DD/YYYY") it results the proper date format, but it's in text. I've tried Format([TEXT],#mm/dd/yyyy#) and receive an error. The goal is to have one query that will change a text format column to a date format without having to go into table design view and change the format.
Please help,
Thanks
Andy
I'm attempting to change a column from TEXT to a date format in a query. When I use Format([TEXT],"MM/DD/YYYY") it results the proper date format, but it's in text. I've tried Format([TEXT],#mm/dd/yyyy#) and receive an error. The goal is to have one query that will change a text format column to a date format without having to go into table design view and change the format.
Please help,
Thanks
Andy