Am I just being really silly here?

 

I am trying to write this formula:

IF currentdate = 17/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE})) ELSE
IF currentdate = 18/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/2 ELSE
IF currentdate = 19/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/3 ELSE
IF currentdate = 20/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/4 ELSE
IF currentdate = 21/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/5 ELSE
IF currentdate = 22/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/6 ELSE
IF currentdate = 23/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/7 ELSE
IF currentdate = 24/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/8 ELSE
IF currentdate = 25/11/2011 THEN (Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/9 ELSE
(Sum ({@SPECIALS WEEK}, {TRNSTK.STCODE}))/9

 

 

but it is telling me  "A date is required here" where I have typed 17/11/2011

 

Is this just incorrect formatting? how can I resolve this?

 

Thanks.

 

I used nov 16th because I that gave me the same as your If-then division days.

I could have also used

datediff('d',date(2011,11,17),currentdate) +1 which is closer to the way you wrote your if-then statements but not as elegant.

Does that help?