Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
try this
var number HotelDays =
ToDays([Hotel Check-Out Date]-[Hotel Check-In Date]);
IF(
$HotelDays <=7, $HotelDays *175,
$HotelDays *125)
The formula uses a formula variable to avoid repetition.
https://help.quickbase.com/user-assistance/formula_variables.html
var number HotelDays =
ToDays([Hotel Check-Out Date]-[Hotel Check-In Date]);
IF(
$HotelDays <=7, $HotelDays *175,
$HotelDays *125)
The formula uses a formula variable to avoid repetition.
https://help.quickbase.com/user-assistance/formula_variables.html