RE: Dates

The UK's most regular instructor-led training courses.
Training information: access vba courses · Microsoft access courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

RE: Dates

Mohammed has attended:
Access Intermediate course
Access Advanced course
Access VBA course

by - delegate Mohammed [3 posts] (2008 Mar 5 Wed, 15:12) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	2	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Dates

by - trainer Pete platinum contributer [799 posts] (2008 Mar 13 Thu, 13:31) Reply

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.

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· The Benefits of Certified Microsoft Training in Access
· Learn about Subqueries in Access Courses
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Microsoft Access Courses

Please browse our web site to find out more about
access vba courses and other Microsoft training courses.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips