Assuming that you've got a recordset called "rs" and that the date is in a field called "date":
I'm almost positive that there is a more elegant and/or proper way to do it, but that's my first run. Just keep in mind that I didn't test it, so there might be something that my decaffeinated brain missed.
Oh, and before I forget:
- Jan through Sept. will not have the leading zero as Month() gives you 1 through 9 for the appropriate month - if a 2 digit month is absolutely needed you will have to pad accordingly.
- Year() gives a 4 digit year - if a 2 digit year is absolutely needed you will have to trim accordingly.
Topic Locked
Posted - 05 December 2007 : 15:30:35
