between ... and ...

J

Jason

Hi.

I was wondering how i could set up a query where the begindate must be every
24th of the month and the enddate every 23th of the month.

If the begindate is a weekday than it should get the next workday instead if
it is a day in the weekend. This is because the 24th of the month is payday
and i get always before or after the weekend if the 24th is a weekday.
 
Top