Adding 3 months to first of month, not actual date?

[Guest]

I have a date field in my database that represents the date a payment was
made. The date can be any day within a month. There's also a field
representing when the payment is through, which should be three months later,
on the last day of the month. I'm trying to update the paid through date.

How would I write an expression to make sure the second field is always on
the last day of the month? For example, if the payment is on 1/10/07, the
paid through date should still be 3/31/07. I'm guessing I need to update the
payment date to be the first, then add 90 days, but not sure how.

 

[Guest]

DateSerial(Year(dteDate), Month(dteDate) + 4, 1) - 1

Where dteDate = payment date.

 

[Allen Browne]

Try:
DateAdd("m", 3, PayDate - Day(PayDate) + 1)

 

[Guest]

Perfect! This did it. Thank you.

DateSerial(Year(dteDate), Month(dteDate) + 4, 1) - 1

Where dteDate = payment date.