Unanswered: Help on calculating a date to run a report on
I am trying to write an expression in a query that will calculate a date. I want to take a birth date and come up with January 1 of the previous year. For example, if I have a birth date of 10/25/86, I want the calculated date to show 1/1/85. Or if I have a date of 5/26/83, I want it to be 1/1/82. Any help in this matter would be greatly appreciated.