system
#1
I have a variable called whose formula is:
- Mod(DayNumberOfWeek() + 1 , 7)
Where is the calendar date from my Date table.
I need to count the number of applications between and + 7 Days.
I thought I could use:
Count() Between ( , RelativeDate(,7))
But it returns an “Incorrect Data Type (DMB00003)” error and places the cursor at the end of my formula.
Am I doing something fundamentally wrong? I’m thinking this should be an easy task.
Thanks!
SeanB (BOB member since 2004-02-11)
system
#2
Try:
Count (...) WHERE ( ...)
And see the FAQ Reporter Entry:
Andreas (BOB member since 2002-06-20)