RE: Witango-Talk: Date Issue

[Tom Ferguson]

try using <@datetosecs> on both dates.  Then compare the results.

 

<@assign temp_curr_date <@datetosecs date=<@currentdate>>>

<@assign temp_exp_date <@datetosecs date=?Your_expdate?>>

 

then compare the temp_curr_date to temp_exp_date.

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Kevill
Sent: Tuesday, December 31, 2002 10: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