how to show date before 1 year ago?

[Jon]

Greeing,

Is there any way to show date before 1 year from specific date in query??
once the query opened , a dailog box shows and aske about the date.

thanks!!

 

[Wolfgang Kais]

Hello Jon.

Is there any way to show date before 1 year from specific date in
query?? once the query opened, a dailog box shows and asks about
the date.

DateAdd("yyyy", -1, Date())