>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?
Ah - sorting and calculating dates...
The only way to calculate is to use <@DATEDIFF>. Sorting should work, so long as the
date is held in a Date field in the database (on Filemaker, anyway)
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
