the DateAdd

[azhar2006]

Hi All
I'm trying to understand this formula. To be exact I'm trying to make this formula work as rolling months
Between Date() And DateAdd("d";-35;#01/01/2014#)
I do not want to show a history of less than 35 days

[ItsMe]

Maybe something like this?

WHERE ((tblName.FieldName) Between DateAdd("d"; -35; Date()) And Date());