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 1...
  • EverettPatterso's avatar
    EverettPatterso
    5 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
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
5 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
------------------------------