past due billing query 1

[brandys]

I am building a past due billing query that pulls recorda that are 30, 60 or 90 days past due. The problem that I am having is the query for the 30 day is pulling all records for 30 days or more not for just the 30 day. The same for the 60. It pulls records for 60 and above. The criteria for the 30 day query (in the bill date field) <=date()-30. This is repeated for the 60 and 90 day queries as well. I have tried several things to get past this but I am coming up with nothing that is working. Please Help.

 

[Geekmomz]

You need to set it to 'Between Date()-60 and Date()-30' for the 30 days to work right. Otherwise, you are telling it to find everything earlier than 30 days ago.

HTH
Geekmomz

 

[brandys]

I tried putting in between date()-60 and date()-30 and it did not pull the records that were 30 days past due. Did i do something wrong again?

 

[Geekmomz]

Oops! Change it to 29.