1 Reply Latest reply on May 11, 2015 3:30 PM by philmodjunk

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

    JoeSimenstad

      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.