Date formula

[pungigi]

I have an appt date field in a form letter, I need to use the appt date but add a "timeframe" to it, example.

This certification is good until {TAPTDT}/7-18-2004

I need it to show

This certification is good until {TAPTDT}/10-18-2004

Any help would be appreciated.

 

[kskid]

Use the DateSerial function. It will even adjust the year automatically.

DateSerial(Year,Month,Day)



DateSerial(year({tapdt}),Month({Tapdt})+3,Day({Tapdt})