Skip to Content
1
Former Member
Feb 11, 2015 at 04:35 PM

Month Must be between 1-12

44 Views

We are running a report with filter of the following:

if {tblWorkInProgress.Date21} in [date(year(currentdate),month(currentdate),1) to

dateadd("d",-1,date(year(currentdate),month(currentdate)+1,1))]then

true

Now obviously this error only happens when the report is tried to run in December as current month of 12 plus 1 is 13 which doesn't exist. So the report is working perfect now.

But how can I accomplish this same thing so the report works all year. I didn't build this report just inheriting it.

Thanks