Calculating Per Diems Across Multiple Weeks
I am really stumped on this one and need some help. The user will select the Hotel In - is on or after (this is actually the Hotel Check-Out Date to give me one part of the range). Then they will sel...
Forum Discussion
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