Need a NextWeek function or script?

[Sandy R]

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

[LaRetta]

Hi Sandy,

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

Get ( CurrentDate ) + 7

LaRetta

[Sandy R]

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

[LaRetta]

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.'