RE: Witango-Talk: Date Issue

[Janet Case]

Hi Steve

To avoid all these issues I convert all my dates to Seconds using the Date To Seconds MetaTag,  then I do the sorts and comparisons on the socnds result.

If you want I can find you actual examples, but you should have no trouble if you look at the DateToSecs Meta tag.

Good Luck Janet

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Kevill
Sent: Tuesday, December 31, 2002 11:44 AM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Date Issue

I'm sure this has been asked before but I can't find it anywhere.

I have a simple IF statement inside an HTML results page. It compares an expiration date to the <@CURRENTDATE>.However, it thinks that 01/01/2003 is less than 12/31/2002.

 

Also when I <@SORT> on this column, it does the same thing. But when I order by in the search action, the records are displayed in the right order. The way the application works, I have to do the sort on a different column before I make the comparison. Can anyone shed some light on this situation?

 

 

Thanks,

Steve