Format date!

  • Thread starter Thread starter Guest
  • Start date Start 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
 
Use DateSerial() to combine the 3 numbers into a date, e.g.:
DateSerial([MyYearField], [MyMonthField], [MyDayField])
 
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...
 
Back
Top