If you champdate attribute has the datatype date you can filter exactly the way you stated in your post, the comparison is done via the timestamp of the attribute.
If however your attribute champdate has the datatype string things get more complicated. You can transform the output of currentdate() to a more readable date using the datetime() function of EZ. But to compare the dates properly they must be of the format YYYYMMDD and the comparison must be done on a integer basis. With your date format of 'JJ/MM/AAA' (what to me translates as day/month/year using two or three digits) a comparison is not possible as the first of an arbitrary month will always be earlier than the second of another month, no matter what the respective months (or years) are.
Greetings from Luxembourg
Claudia
You must be logged in to post messages in this topic!
