98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » RE: Dates
RE: Dates
Resolved · Low Priority · Version Standard
Wed 5 Mar 2008, 15:12Delegate Mohammed said...
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
Thu 13 Mar 2008, 13:31Trainer Pete said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Insert The Current TimeTo insert the current time into a Table field or Form textbox use: |
