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
Sorry, I forgot that we are already a numeric field.
so we just need +1 and not + Days(1)
IF(
IsNull($ShipDate), $DaysStoredPriorMonth + 1, // still //here, so count Last Day of the month
$ShipDate > $LastDayofPriorMonth,
$DaysStoredPriorMonth + 1, //left after EOM, so //count last day
$DaysStoredPriorMonth) // else left during month so don't //charge last day
As for our other question,
"Does your brain just work this way all the time-do you write "code" for a living??? "
The answer is yes and yes.
I used to have a real job with 100 people reporting to me and meetings and budgets up until 11 years ago. Then we sold the family business and I needed Plan B. So now I solve puzzles using Quick Base for my clients, ie I write apps and help them when they get stuck. So, it's not really work, it is more like paid puzzle solving.
so we just need +1 and not + Days(1)
IF(
IsNull($ShipDate), $DaysStoredPriorMonth + 1, // still //here, so count Last Day of the month
$ShipDate > $LastDayofPriorMonth,
$DaysStoredPriorMonth + 1, //left after EOM, so //count last day
$DaysStoredPriorMonth) // else left during month so don't //charge last day
As for our other question,
"Does your brain just work this way all the time-do you write "code" for a living??? "
The answer is yes and yes.
I used to have a real job with 100 people reporting to me and meetings and budgets up until 11 years ago. Then we sold the family business and I needed Plan B. So now I solve puzzles using Quick Base for my clients, ie I write apps and help them when they get stuck. So, it's not really work, it is more like paid puzzle solving.