weekday date function

[camg12]

Right now my query is pulling all the records within the past week using:

Between Date() And Date()-6

How do I exclude the weekends? So it will include data for example from Thursday to Thursday but not including Saturday & Sunday.

 

[raskew]

Hi -

Try adding an additional field to your query:

Weekday([DateField])

In the criteria cell:

Not In ("17")

1 being Sunday and 7 being Saturday.

HTH - Bob

 

[camg12]

Thanks for your help.

 

[raskew]

Glad to help out.

Bob

 

[gemma-the-husky]

would

Not In ("17") work?

if not try

Not In ("1", "7")

 

[Brianwarnock]

I know it works but why put"" round a numeric value
Not In(1,7) saves typing.

Brian

Curiosity made me test
Not In("17") It doesn't work but I guess the OP managed to work it out since they didn't complain.