Can someone please provide me with the code for me to put it in a Microsoft access query to format a date?
the current format is as follow: 06132003
I like to format it as 06/13/2003 but the data is stored in the text field with the above format.
I like to change it with a query and make a new table with the new date format..
I just need the code to be able to that...