Skip to main content
Solved

Set seasonal rates automatically

  • October 1, 2019
  • 0 replies
  • 57 views
Forum|alt.badge.img+1
Take for instance you have three hotels each in a different country and all have different rates which change by season. High season is from Nov 14 to April 14 and low season is from April 15 to Nov 15 every year.

For example:

Is it possible to automatically populate the seasonal rate ((high or low) based on the current date? If yes, how?

------------------------------
Ijnanya Isaac
------------------------------

Best answer by EverettPatterso

You can make a formula numeric field

var date mydateone = Date(Year(Today()), 4, 15);
var date mydatetwo = Date(Year(Today()), 11, 15);

If(Today()>=$mydateone and Today()<=$mydatetwo, [Low], [High])​


------------------------------
Everett Patterson
------------------------------
    This topic has been closed for replies.

    EverettPatterso
    Forum|alt.badge.img+10
    • EverettPatterso
    • Quickbase Alumni
    • Answer
    • October 1, 2019
    You can make a formula numeric field

    var date mydateone = Date(Year(Today()), 4, 15);
var date mydatetwo = Date(Year(Today()), 11, 15);

If(Today()>=$mydateone and Today()<=$mydatetwo, [Low], [High])​


    ------------------------------
    Everett Patterson
    ------------------------------
      • RyanStanford1
      • Quickbase Alumni
      • October 1, 2019
      My Company has done something similar but with using a child "Rates" table... the Rates have Start Date and End Date, and relationship/summary fields for what's the Maximum RecID of Active Rate.

      However, that does seem pretty complex since you already have the high and low of each hotel in the same table...

      ------------------------------
      Ryan Stanford
      ------------------------------
      Terms & ConditionsAccessibility statement