Date range of [datefield] minus 1 year

[Stacey]

I have been looking through the search results using various phrases to try to find what I need. I probably have found it but just don't know how to apply it. I have a Date_Created field to pull back payment information. There is another field, SignDate, on another table. I need to pull back any payments between the SignDate and a year prior. There are many records, with different SignDate's. I was messing with the DateSerial function, but I just don't know how to make it work. Both the Date_Created and SignDate fields are formatted as mm/dd/yyyy.

Sorry if this has been answered and I'm just not getting it.

 

[rainman89]

use

Between (dateadd ( "y", -1, [sign date])) AND [Sign date]

 

[Stacey]

Thanks for your reply.

However, with the SignDate as 9/5/2006, Between (dateadd ( "y", -1, [SignDate])) AND [SignDate] is bringing back everything greater than 9/5/2006 in the results.

 

[raskew]

Should be:
...(dateadd ( "yyyy"

"y" refers to Day of Year.

Bob

 

[Stacey]

Great! Thank you!

 

[rainman89]

oops... yeah my bad!