Hi,
I have a table that contains many column but one of the columns is the "Collected Date". the dates entered in this column in in this format: 2013.10.28 however I to upload this table in another software to analyse, I need the date to be in this format: 10/28/2013
Is there a query to help me with this?
I already tried changing the format in the design view but since the format is currently in text it does not allow me to change the format into date!
please help :banghead:
I have a table that contains many column but one of the columns is the "Collected Date". the dates entered in this column in in this format: 2013.10.28 however I to upload this table in another software to analyse, I need the date to be in this format: 10/28/2013
Is there a query to help me with this?
I already tried changing the format in the design view but since the format is currently in text it does not allow me to change the format into date!
please help :banghead: