I need to have a script or function that returns the date of the "next" week from the current date ...

In other words, the date 7 days in the future. I can't seem to cobble together the right combination of calcuations...any date calculation gurus out there ;-)

thanks..Sandy

Hi Sandy,

If you want exactly 7 days ahead of the current date, try:

Get ( CurrentDate ) + 7

LaRetta

Can we all say duhhh ;-) Thanks!

I had tried Get(CurrentDate +7) but that doesn't fly.

Will this work over a year boundary?

Sandy

Yep, it will work over the year boundary. FM is great at keeping track of its date fields. And it will keep appropriate track over the month boundary as well - even leap year. If this is a calculation, set it to 'Unstored.'