Searching for data by day of the week, but need last full month

[Rosy1]

I got help last week with a problem looking for data for specific days of the week. Someone answered and suggested the following formula to retrieve data for Sunday & Saturday.
{CollectDate} in dateadd("ww",-4,currentdate) to
currentdate and dayofweek(collectDate) in [1,7]

This formula worked, but I only retrieved data from the last week of Sepember. I need the full month of September. Can anyone help?

Thanks... Rosy1

 

[rhinok]

This should do the trick:

{CollectDate} In LastFullMonth

 

[Rosy1]

I did that in the original formula. But I still only get the last weekend of the month.
This is what I entered:
{@date} and
{CrossReference_VIEW.CollectDateODBC} in LastFullMonth and
{CrossReference_VIEW.TestCode} like ["CFX", "HEXPA", "HPIA"]

Any other suggestions? Thanks... Rosy1

 

[rhinok]

Is that only a partial record select statement? What does {@date} do? Also, {@date} won't be passed to the DB server without certain steps.

Try removing all other criteria except

{CrossReference_VIEW.CollectDateODBC} in LastFullMonth

to see if you are returning the right data. Then add in other criteria to see how your dataset is affected.