date manipulation- question

[Boyan]

Problem: how to make calculated control which calculates "first_day_of_previous_month", based on [today]?

and

"last_day_of_previous_month", based on same pre-entered date?

(On the same form)

thanks!

B.

 

[Geoff Codd]

I use this to convert the entered date to the last day of the month you should be able to play with this to get what you want

Me![End of Month Billing Date] = DateAdd("d", -1, Format("01/" & Format(DateAdd("m", 1, Me![End of Month Billing Date]), "mm/yy"), "dd/mm/yy"))