Format date!

G

Guest

Hi,
I have a link done to a AS/400 database.
3 fields represents a date. Day - Month - Year (2 digits each/number format)
I create a new Text box where I concatenate these 3 fields as 00/00/00.
But !!! I get 1/6/7.
I know that in Excel I can use the Text formula to force the format to be
00/00/00 with the =Text(A1;"00\/00\/00").
Can someone tell me what is the right formula to Access!
Tanks 4 the help.
Barbara
 
A

Allen Browne

Use DateSerial() to combine the 3 numbers into a date, e.g.:
DateSerial([MyYearField], [MyMonthField], [MyDayField])
 
G

Guest

Thank you Allen, it works just fine.

Allen Browne said:
Use DateSerial() to combine the 3 numbers into a date, e.g.:
DateSerial([MyYearField], [MyMonthField], [MyDayField])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Barbara said:
Hi,
I have a link done to a AS/400 database.
3 fields represents a date. Day - Month - Year (2 digits each/number
format)
I create a new Text box where I concatenate these 3 fields as 00/00/00.
But !!! I get 1/6/7.
I know that in Excel I can use the Text formula to force the format to be
00/00/00 with the =Text(A1;"00\/00\/00").
Can someone tell me what is the right formula to Access!
Tanks 4 the help.
Barbara
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Have I a Hardware Problem? 8
Pivot table macro filter data between yesterday and today (date+time) 0
HELP! What's Up With Time 2
How to SELECT with date criteria by SQL? 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Date format 3
Additional value is added to date value or time value after exportingaccess data to text format 2
Date & time Data Type formatting 1

Top