I'm trying to figure out how to script a find to pull up next week's depos. I'm using FMP to manage a depo schedule and every Wed and Fri of the current week we need to report to the client what depos are scheduled the following week. I'm using FMPv10 (advanced) and we have the solution hosted on FMSv10.

I'm using global calc fields to evaluate what today's date it, and add x number of days depending on what day of the week today is. For the end date of the range I'm taking the results of the start date calc and adding 4 days.

For whatever reason, its not updating or refreshing the date range as we proceed through the week.

Anyone have a solution or know of a previous post that will show me the proper way to set this up on a hosted solution so that each user when running the reports can have FMP automatically pull up next weeks records?

Thanks

I'm using global calc fields to evaluate what today's date it

Global calculations are stored and will not recalculate on their own. You should use unstored calculations - but you don't actually need any fields for this. Try:

Enter Find Mode[]

Set Field [ Datefield ; Let ( sat = Get (CurrentDate) - DayOfWeek ( Get( CurrentDate) ) ; sat + 8 & ".." & sat + 14 ) ]

Perform Find[]