finding the end of the month

[Peanuts]

Ok, I'm thick headed, I'm just not catching the clue on working with dates.

Comming from my form to my report I have a set date relating to that particular form/person. That date might range from 01/03/1999 to today's date. I need to make another text box that returns the end of the month equal to whatever the date is in the preset box.

Example: preset date 11/08/2001. New text box 11/30/2001.

Thanks for all your help

pat

 

[raskew]

From the debug window <Ctrl + G>

dteMyDate = date()
? dteMyDate
3/19/03
LastDayOfMonth =DateSerial(Year(dteMyDate),Month(dteMyDate)+1,0)
? LastDayOfMonth
3/31/03

 

[Peanuts]

Enter Parimeter Value?

This code works from the debug window, but for the life of me I can't get it to work in the text box on my report. I either get a blank box, or an enter parimeter value?

Any other ideas?

Thanks

Pat

 

[Peanuts]

I Figgered it out !

Hey, Many Thanks to Raskew,
I finally figgered it out. He was exactly right and If I had any inkling of what I was doing I would have seen my mistakes earlier.