--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
From: "Tom Ferguson" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 31 Dec 2002 13:37:39 -0500
To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
Subject: RE: Witango-Talk: Date Issue
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
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
