Need function to get programmatically get the first of the year

[Fiat77]

Based on Date() I need to get the first of the year 10 years ago to use as a criteria in my query

So for example for today's Date() I need it to get back 1/1/1995.

I was trying to think of how to use DateAdd or DateDiff with the Date function but wan't sure how

Thanks

 

[SkipVought]

Hi,

dateserial(year(MyDate)-10, 1, 1)

Skip,
[sub]
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie![/sub]

 

[Fiat77]

Thanks a lot Skip!!!!