I have an access adp with a SQL back end. I am trying to filter a report as such:
Dim sFilter As String
sFilter = "[Active]=yes and [MaxofDate1] > '" + Str(DateAdd("d", -30, Now())) + "' "
Me.Filter = sFilter
Me.FilterOn = True
It keeps giving me todays date Instead of 30 days prior to now. How do I use the DateAdd in SQL to give me 30 days prior to today?