Comparing date field with current system date

[#1]

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

[#2]

You can try something like:

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