Calculating Number of Months and Days between 2 dates?

Question

Hey there,
I have two fields [Start Date] and [End Date], where I need to calculate the number of Months and Days between them.For Example:[Start Date] = 08-30-2019[End Date] = 10-01-2019Should come out to '1 month, 1 days', but due to the variance in the number of days in each month, I can't for the life of me figure out how to reliably calculate this. The state requires it presented as 'x months, x days', so I can't have it be approximate.
If anyone could provide me with some guidance that would be greatly appreciated!

Thank you.------------------------------Curtis McHenry------------------------------

XavierFan · Answer

I think you'd need a definition from the state as to how they define a "month".

Do they have any examples of calculations?

We can think of any number of ways to calculate this - but sounds like what matters is what the state accepts as "accurate".

------------------------------
Xavier Fan
------------------------------

Sign up

Login to the community