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