Mohammed has attended:
Access Intermediate course
Access Advanced course
Access VBA course
RE: Dates
Hi
I was wondering that how would you change an reversed date from a CSV file and convert it into a short date format,
for example
19991023 converting this into 23/10/1999
Help in this matter would be greatly appreciated.
Regards
Mo
RE: Dates
Hi Mohammed, Thanks for the post, I dont really know how to approach this one in Access, however in Excel you could try the conversion with Paste Special. Select a blank cell, Choose Edit>Copy, Select the cells which contain the numbers; Choose Edit>Paste Special, Select Add, Click OK, To apply the number formatting choose Format>Cells, on the number tab, select the appropriate format then click OK. You could then import the table into Access. I hope that helps, best regards Pete.
