Expired Account

[nx69]

I have a query called qryExpiringAccounts, that calculates tha date of expiration and has as criteria >=Date() And <Date()+7 and it works great. I have an other query called qryExpiredAccounts with the same structure but it has <Date() for criteria and it doesnt work.(there have to be results because i created an account with date of expiration smaller than today) What is wrong?

 

[doran_doran]

Now and Date Functions....

>=(Now()) And <(Now()+7)
>=(date()) And <(date()+7)

I tried both and they seems to work. Make sure to you have some data that impact this query since, You are pulling anything going forward. I tried less than it worked. I tried greater than and I did not get any results and it makes sense b/c I dont have any date passing today's date. So I changed few records with higher date than today's date and the greater than worked fine.

Good Luck.

Dianna Goldsberg

 

[Mile-O]

Haven't I answered this for you before? The week prior to expiry over three account types? I think I have....

 

[nx69]

irema

Haven't I answered this for you before? The week prior to expiry over three account types? I think I have....

you told me how to calculate the date of expiration

Thanks jam and mil.

 

[Mile-O]

you told me how to calculate the date of expiration

Actually, I remember telling you how to calculate one week before the date of expiration.