AnsweredAssumed Answered

Creating a 7 Day View using Portals and Filtering Results using Get ( CurrentDate ) + 1

Question asked by JoeSimenstad on May 11, 2015
Latest reply on May 11, 2015 by philmodjunk

Title

Creating a 7 Day View using Portals and Filtering Results using Get ( CurrentDate ) + 1

Post

 

Hello Everyone,

I am trying to create a small scheduling database. I need to see a 7 day view of upcoming clients. I want to use multiple Portals with a detailed view inside those portals of clients scheduled on a certain day. Using one of the templates included with FMP, I can get the "Today" view to work, but I need a view for "Tomorrow" and so on.

I am trying to use the "Perform Find [Restore]" part of the script.
I have a variable... Set Variable [$TODAY; Value:Get ( CurrentDate )]
Today works fine, but then I have a criteria for Tomorrow
[= $TODAY + 1]
This does not work.

Yet, in the forums I see a lot of people using "Get ( CurrentDate ) -1" and things like that.

I simply want to create several portals that do a Record Find each one doing a "Get ( CurrentDate ) + 1", "Get ( CurrentDate ) + 2", "Get ( CurrentDate ) + 3", "Get ( CurrentDate ) + 4" and so on.

Any suggestions? Thanks in advance for your help!

Joe

PS. I can't believe there isn't some sort of calendar view built into FMP. I found several on the web, but they are WAY more than I need.

Outcomes