Sql statement to retrieve prior month data using computer date as reference

[hapm]

what is the type of DATECOLUMN?

[hapm]

Can you please copy the full query from SQL view? As you wanted to go back 90 days perhaps it's better to use DateAdd("d",-90,Date())

[Shilabrow]

Please assist in getting this right. I am trying to get data for 3 months to date using computer as reference time. Thanks - All help appreciated. The below query gives me 3 month data excluding current month but I want 3 months to date records.

[Purchase Orders].[Creation Date] BETWEEN DateSerial(Year(Date()),Month(Date())-3,1) AND DateSerial(Year(Date()),Month(Date()),0)

[hapm]

Use the DateAdd approach. If there is a data type missmatch it shouldn't be the fault of DateAdd in general. DateAdd is the way to go.

[Shilabrow]

hapm, thanks - but when I use DateAdd("d",-90,Date()), I get nothing at all Also I used DateAdd("m",-3,Date()) And Date() -- still nothing. Am I missing something? I appreciate your help. Thanks!

[hapm]

Not sure, please show the full query with DateAdd

[Shilabrow]

O.K. Hapm - Thanks, after so much back and forth. I made adjustment to ur last query and used this; since Date() is to date and it giving about what I need. Thanks to all for support

Between DateSerial(Year(Date()),Month(Date())-2,1) And Date().