I'm trying to figure out a formula that would give me the end date for what ever the field month and year it comes up with to report the end of the date for the month. Example 7/12/2012 to say 7/31/2012. So I used the below formula.

DateAdd ("m", 1, DateTime( Year({table.End_of_date}),
Month({table.End_of_date}), 1, 0,0,0)) - 1

but also trying to use this with it

IF totext ({table.End_of_date}) <> " "
then totext ({table.End_of_date},"MMddyyyy")
else totext ("        ")

I tried to the best of my knowledge to put work this out but keep getting boolean errors. Any help is greatly appreciated.