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
Katie, For this you will need the field that has the month you are calculating. For example : if someone stayed for 3 months from 15th Jan to 20 April, there are different number of days that person has stayed in each month.
If you just need to know January (first month from the date admitted) that is fairly simple. Just use the following formula :
ToDays(Min(LastDayOfMonth(Date(Year([BTC Admission Date]),Month([BTC Admission Date]),1)),[BTC Discharge Date]) - [BTC Admission Date])
If you just need to know January (first month from the date admitted) that is fairly simple. Just use the following formula :
ToDays(Min(LastDayOfMonth(Date(Year([BTC Admission Date]),Month([BTC Admission Date]),1)),[BTC Discharge Date]) - [BTC Admission Date])
- Thank you Avinash-trying it out-not lucky so far...But I appreciate the thought behind this.
