Rates for last-minute reservations

Q: How do we make a higher Rate for last-minute reservations, e.g. if they make the reservation less than 2 days in advance?

A: If you're using version 4.2.2 or later, you can do this using the "Advanced Condition Expression" setting in the Rates definitions.

Create a new rate definition (e.g. make a copy of the normal daily rate), with the amount changed for the last-minute rate.

Then, put this in the Advanced Condition Expression:

 Days(Resv:Resv_First_Date, Resv:Resv_Date_Made) <= 2

It has to be exact, so use copy/paste if possible.  The Days() function shown calculates the number of days between the first night of the reservation and the date it's made (e.g. like subtraction), so this rate will apply if it's made 2 or less days before it starts.

Also note that you should have this rate above the normal daily rate in the list (so it checks these conditions first), so this rate has priority over the normal rate.