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
Does your brain just work this way all the time-do you write "code" for a living??? Its like speaking another language-
I do get this syntax error:
The expression $DaysStoredPriorMonth on the left hand side of the operator "+" is of type number while the expression Days(1) on the right hand side is of type duration. The operator "+" cannot be used with these types of expressions.
I read up on days and duration not cooperating-but not sure what would be changed to make this work? Can I flip so it reads "Days(1) + $DaysStoredPriorMonth" or does that do more harm? I tried a adding a plus sign to the "Days(+1)....didn't work...
I do get this syntax error:
The expression $DaysStoredPriorMonth on the left hand side of the operator "+" is of type number while the expression Days(1) on the right hand side is of type duration. The operator "+" cannot be used with these types of expressions.
I read up on days and duration not cooperating-but not sure what would be changed to make this work? Can I flip so it reads "Days(1) + $DaysStoredPriorMonth" or does that do more harm? I tried a adding a plus sign to the "Days(+1)....didn't work...