Comparing date field with current system date

Fri, 01 May 2009 16:59:46 GMT

I have a category field which I must set based on certain conditions being true.

one of these conditions is:

set category to 'A' if the field, IEADVDELIVERYDATE is within this current week.

so if that date field is between Monday and Sunday of the same week that the system date is within

There is also a second Category where the date field is compared to Monday to Sunday of the PREVIOUS week.

Can anybody suggest how I can do this please?

thanks in advance,

Matt

Fri, 01 May 2009 17:09:27 GMT

You can try something like:

inweektodate ( IEADVDELIVERYDATE, Today(), 0 )
inweektodate ( IEADVDELIVERYDATE, Today()-7, 0 )

topic Comparing date field with current system date in QlikView