Forum Discussion

AnyaIT's avatar
AnyaIT
Qrew Member
7 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 1...
  • EverettPatterso's avatar
    EverettPatterso
    7 years ago
    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
    ------------------------------
EverettPatterso's avatar
EverettPatterso
Qrew Captain
7 years ago
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
    7 years ago
    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
    ------------------------------