Forum Discussion

AnyaIT's avatar
AnyaIT
Qrew Member
5 years ago
Solved

Set seasonal rates automatically

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
------------------------------
  • 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
    ------------------------------

3 Replies

  • 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Ijnanya, 
      Everett's post above can be modified to vary by Hotel if the High Low dates vary by Hotel.


      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------
  • 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
    ------------------------------