Access VBA

The UK's most regular instructor-led training courses.
Training information: microsoft access training class · Microsoft.access.courses · VBA courses London

Resolved · Low Priority · Version Standard

Access VBA

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

by - delegate Mohammed [3 posts] (2008 Mar 9 Sun, 08:44) Reply

how can you concatenate a date field from yyyymmdd to read dd/mm/yyyy in access?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access VBA

by - trainer Rich platinum contributer [711 posts] (2008 Mar 18 Tue, 12:36) Reply

Hi Mohammed,

A few things you can try...

1) You could try the Format function:

Format ( expression, [ format, [ firstdayofweek, [firstweekofyear] ] ] )

eg. Format ( yyyymmdd, "dd/mm/yyyy")

See more: http://www.techonthenet.com/access/functions/date/format.php

2) If it's an import, you can adjust it in Excel first, like this:

If A1 equals the yyyymmdd value, enter this in B1:
=RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)

... to get the proper format.

Hope this helps.

Regards, Rich