Select date range

[FlyGuyTray]

I would like to select items that are 45 days old.. I could count the days and use the ">=" but is there a simpler way?

 

[boblarson]

If you want anything 45 days old or newer for your criteria you would use

Between DateAdd("d", -45, Date()) And Date()


for just 45 days

DateAdd("d", -45, Date())


for 45 days and older

<= DateAdd("d", -45, Date())

 

[FlyGuyTray]

Thanks Bob!