Extracting 2 year history of data

[Guest]

I am attempting to extract a 2 year history of data based on a date in my
query. I have tried using the following syntax but it returns data prior to
2 years:

DatePart("yyyy",[FundedDate]-1)

Now, I can use the criteria of > "1/1/2004" but this requires annual
maintenance. Any ideas?

 

[Rick B]

Use datediff to subtract 2 years from the current date and use that in your
"greater than" statement in the criteria.

I am attempting to extract a 2 year history of data based on a date in my
query. I have tried using the following syntax but it returns data prior to
2 years:

DatePart("yyyy",[FundedDate]-1)

Now, I can use the criteria of > "1/1/2004" but this requires annual
maintenance. Any ideas?

 

[Rick B]

Oops - That won't work.

I'm trying a few ideas. Ignore previous post.

I am attempting to extract a 2 year history of data based on a date in my
query. I have tried using the following syntax but it returns data prior to
2 years:

DatePart("yyyy",[FundedDate]-1)

Now, I can use the criteria of > "1/1/2004" but this requires annual
maintenance. Any ideas?

 

[Rick B]

Ok.

Try...

DateSerial(Year(Date())-2,Month(Date()),Day(Date()))

Hope that helps.


Rick B

I am attempting to extract a 2 year history of data based on a date in my
query. I have tried using the following syntax but it returns data prior to
2 years:

DatePart("yyyy",[FundedDate]-1)

Now, I can use the criteria of > "1/1/2004" but this requires annual
maintenance. Any ideas?

 

[Guest]

That worked. I tried using Date Serial but did not have the correct syntax.

Thank you Rick

Ok.

Try...

DateSerial(Year(Date())-2,Month(Date()),Day(Date()))

Hope that helps.


Rick B

I am attempting to extract a 2 year history of data based on a date in my
query. I have tried using the following syntax but it returns data prior to
2 years:

DatePart("yyyy",[FundedDate]-1)

Now, I can use the criteria of > "1/1/2004" but this requires annual
maintenance. Any ideas?