Calculate the last day of the month

[Leesha]

Hi,
I am using the following code to calculate a date 10 years later then [FPSubwayREopening]. How would I change the code so that it always finds the last day of the month?

Thanks!
Leesha

DateAdd("yyyy", 10, Me.FPSubwayREopening)

[Rudi]

Hi Leesha,

Try this:

DateAdd("yyyy",10,DateSerial(Year(Me.FPSubwayREopening),Month(Me.FPSubwayREopening)+1,0))

[Leesha]

Perfect!! Thanks so much!!
Leesha

[HansV]

Or

DateSerial(Year([FPSubwayREopening])+10,Month([FPSubwayREopening])+1,0)