Formula Support-Duration # of days in a month
Not sure if I can ask a question from here again? I had help with the original formula-and it is about the same formula(s) I have the formula: Sum([BTC Discharge Date]-[BTC Admission Date]) an...
Forum Discussion
This is the syntax error-Would it mean that I need to change my field name to not have spaces so the first variable works?
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
var date ShipDate = [BTC Discharge Date];
var date ReceivedDate = [BTC Admission Date];
var date FirstDayofPriorMonth = AdjustMonth(FirstDayOfMonth(Today()),-1);
var date LastDayofPriorMonth = LastDayOfMonth($FirstDayofPriorMonth);
var date FirstDayStoredPriorMonth = If(
$ReceivedDate <= $LastDayofPriorMonth and (IsNull($ShipDate) or $ShipDate >= $FirstDayofPriorMonth),
Max($FirstDayofPriorMonth, $ReceivedDate));
var date LastDayStoredPriorMonth = If(
IsNull($ShipDate) and not IsNull($FirstDayStoredPriorMonth), $LastDayofPriorMonth,
not IsNull($FirstDayStoredPriorMonth) and $ShipDate >= $FirstDayofPriorMonth, Min($ShipDate,$LastDayofPriorMonth));
var number DaysStoredPriorMonth = If(
IsNull($ReceivedDate ]),0,
not IsNull($LastDayStoredPriorMonth), ToDays($LastDayStoredPriorMonth - $FirstDayStoredPriorMonth));
$DaysStoredPriorMonth
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
var date ShipDate = [BTC Discharge Date];
var date ReceivedDate = [BTC Admission Date];
var date FirstDayofPriorMonth = AdjustMonth(FirstDayOfMonth(Today()),-1);
var date LastDayofPriorMonth = LastDayOfMonth($FirstDayofPriorMonth);
var date FirstDayStoredPriorMonth = If(
$ReceivedDate <= $LastDayofPriorMonth and (IsNull($ShipDate) or $ShipDate >= $FirstDayofPriorMonth),
Max($FirstDayofPriorMonth, $ReceivedDate));
var date LastDayStoredPriorMonth = If(
IsNull($ShipDate) and not IsNull($FirstDayStoredPriorMonth), $LastDayofPriorMonth,
not IsNull($FirstDayStoredPriorMonth) and $ShipDate >= $FirstDayofPriorMonth, Min($ShipDate,$LastDayofPriorMonth));
var number DaysStoredPriorMonth = If(
IsNull($ReceivedDate ]),0,
not IsNull($LastDayStoredPriorMonth), ToDays($LastDayStoredPriorMonth - $FirstDayStoredPriorMonth));
$DaysStoredPriorMonth