When you do the compare like you are doing
by reformatting you are just doing a character comparison. There is no
real reason it won't work unless you have leading zeros that get left out.
For example 2002/05/01 is not equal to 2002/5/1 the way you are comparing.
I changed long ago to keeping all my date
related fields stored as seconds. Then I just do a <@secstodate>
when I want to display them. Then I also don't have to worry about how
different databases store date info.
-----Original
Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Kevill
Sent: Tuesday, December 31, 2002 1:12 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Date Issue
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Kevill
Sent: Tuesday, December 31, 2002 1:12 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Date Issue
Thanks for the help guys. After I sent the email I tried formating the strings with the year first, then the month, then the day and it seemed to work. Anyone know any reason not to do it this way?Thanks Again,Steve
