Current date equaling the first and last of month

[Peanuts]

I have a report that I have to send on random days. I can print it out and the current date showes 03/13/03 just like it is susposed to do. Now, On two other lines in the report it needs to say period beginning March 1, 2003 and the other line needs to say period ending March 31, 2003.

Is there a way that the two "needed dates" can relate to the current date? and make the adjustments for shorter day months like February? and how would I make something like that?

Thanks for all your help !

 

[KevinM]

Create two text boxes.

TextBox 1 control source...

="Period Beginning " & DateSerial(Year(Date()),Month(Date()),1)

TextBox 2 control source...

="Period Ending " & DateSerial(Year(Date()), Month(Date()) + 1, 0)


hth