date to string

[Jean-Paul]

Hi,
I have a table with the date of birth of all students
the format is dd/mm/yyyy
but sometime I get dates like:
1/1/2003
(january the first)
I would like to get 01/01/2003 because I have to create a student number
based upon the date of birth together with our schoolnumber.

Example: 02826620030101

dg = DatePart("d", tb!Geboortedatum)

returns a 1 instead of 01

How to solve this problem?
Thanks

 

[Allen Browne]

Try:
=Format([d], "yyyymmdd")
where d represents the name of your date field.

 

[Jean-Paul]

Perfect... thanks