Get data - 3 months to Date

[Shilabrow]

I am trying to get data for 3months to date. I have the following but I get error when I used the below query for my date criteria. What am I doing wrong. All help appreciated in helping me retrieve all 3months data to date using computer reference time. Thanks

DateDiff("m\on\th","datecolumn",getdate()<=3)

[orange]

I would suggest a SELECT query with
a) WHERE DateColumn Between Date - 90 and Date
b) Where DateDiff("m",DateColumn, Date) <=3

[Shilabrow]

Thanks orange, I get Error: Data type mismatch in criteria expression.

[orange]

I think it's telling you that DateColumn is not a Date/Time datatype.

Check - what is the data type of the datecolumn field in your tabel?