Odd Filter request - filter by month exclude certain days 2

[gogopoppy]

Hi there,

I've had a request to filter a report by the last month's data but to exclude Mondays!

I've tried quite a few things but my formula is not quite working.

Could anyone give me a heads up about how to approach this. Its harder than I thought when I said it was possible.

Any help or direction would be great

Tx in advance

G

 

[ainkca]

Assuming Mondays are the first day of the week, something like this should work:

{yourtable.datefield} in {?StartDate} to {?StopDate}
and DayOfWeek ({casemain.actcase_start_datetime}) <> 1

 

[kskid]

Or this

{yourtable.datefield} in LastFullMonth and
DayOfWeek({casemain.actcase_start_datetime}) <> 1

 

[kskid]

Sorry about that but Monday is 2 not 1

{yourtable.datefield} in LastFullMonth and
DayOfWeek({casemain.actcase_start_datetime}) <> 2

 

[gogopoppy]

Thanks everyone

These are working (I thought it would be a much harder formula)