Dateformat dd/mm/yyyy

<i><b>Originally posted by : Alex Jansen</b></i><br />i use access 2000 , the output i get on my asp page = d/m/yyyy<br />what i want is dd/mm/yyyy , how can i format this output of the recordset<br />

<i><b>Originally posted by : Shaun O'Grady (shaun@greenbutton.ca)</b></i><br />Hi Alex,<br /><br />Try this:<br /><br />'The SimpleDate function assures that the day and month in a date always have 2 digits.<br />Function SimpleDate(originalDate)<br /> dim strDay<br /> dim strMonth<br /> dim strYear<br /><br /> strDay = Day(originalDate)<br /> strMonth = Month(originalDate)<br /> strYear = Year(originalDate)<br /> <br /> If Len(strDay) = 1 Then strDay = "0" & strDay<br /> If Len(strMonth) = 1 Then strMonth = "0" & strMonth<br /> <br /> SimpleDate = strDay & "/" & strMonth & "/" & strYear<br />End Function<br /><br /><br /><br />------------<br />Alex Jansen at 8/3/2002 5:44:35 PM<br /><br />i use access 2000 , the output i get on my asp page = d/m/yyyy<br />what i want is dd/mm/yyyy , how can i format this output of the recordset<br />