Dates

[Trancedified]

Hello,

I was wondering if there's a way to include zero's in a date when I'm running a search on the database. Supposedly "what if" there were zeros in front of a single digit date like 01/01/2001 or 09/22/1922. The search I'm doing is not recognizing 01/01/2001 as a date, it only recognizes dates that are like: 1/1/2002



Any code suggestions to allow the search to include 0's?


Chris

[jemidiah]

I'm assuming that it's stored as a string and not as an actual date (it would then do a numerical comparison and, thus, pass). If so, you might want to look into the FormatDateTime or simply Format functions. They should get you what you want.