H
hobbit2612 via AccessMonster.com
Hi,
I wonder if someone could help me please.
I'm trying to write an expression (see code below) within a query where I
calculate 15 working days from a a given date, in this case the 'Date a
report was sent'.
DateAdd(“wwâ€,15,[Date Report Sent]-DateAdd([Date Report Sent],1)*2-IIf
(Weekday([Date Report Sent],1)=7,IIf(Weekday([Date Report Sent],1)=7,0,1),IIf
(Weekday([Date Report Sent],1)=7,-1,0)))
But when I add it to my query I keep getting this message: 'The expression
you entered has a function containing the wrong number of arguments.'
I'm assuming, maybe wrongly, it's because there are not enough parentheses,
but for the life of me I can't see where.
Could someone give me a helping hand on this.
Many thanks
I wonder if someone could help me please.
I'm trying to write an expression (see code below) within a query where I
calculate 15 working days from a a given date, in this case the 'Date a
report was sent'.
DateAdd(“wwâ€,15,[Date Report Sent]-DateAdd([Date Report Sent],1)*2-IIf
(Weekday([Date Report Sent],1)=7,IIf(Weekday([Date Report Sent],1)=7,0,1),IIf
(Weekday([Date Report Sent],1)=7,-1,0)))
But when I add it to my query I keep getting this message: 'The expression
you entered has a function containing the wrong number of arguments.'
I'm assuming, maybe wrongly, it's because there are not enough parentheses,
but for the life of me I can't see where.
Could someone give me a helping hand on this.
Many thanks