report date help.

[HOMMER]

I write the date on my report with this statement from a form. What I need to do is show this information minus 364 days. I can do it in a query but can not doit on my report...



="Previous " & [Forms]![frm_bm_Report]![txtStartDate] & " to " & [Forms]![frm_bm_Report]![txtStopDate]

 

[THWatson]

Take a look at the DateSerial function. You can use this function to calculate what you want.

If I get a chance to calculate the exact formula this evening, I will post back.
Tom

 

[THWatson]

Sorry, I think the DateAdd function will do it better than the DateSerial function.

In an unbound text box, I plugged the following code...
=DateAdd("d",-364,Date())

This takes the current date and subtracts 364 days.

If you are using something other than the current date, then substitute [your date field] for Date in the formula. In other words...
=DateAdd("d",-364,[your date field])

Hopefully, this will help.
Tom

 

[HOMMER]

Thanks worked great.....