• If there is a report parameter. The fomular will be

    =DateAdd("yyyy",-1,DateAdd("d",-1,Today()))