Is there a formula or function to count the days from the beginning of a period to the end of a period specified to the ARM report form? I tried the following but it’s not giving the correct result:
=DateDiff('d', @PeriodEnd, @PeriodStart)
Solved
How to calculate days from start to end of a period?
Best answer by aborisova94
Hello!
You can try this formula
=DateDiff('d',Report.GetPeriodEndDate(@EndPeriod) , Report.GetPeriodStartDate(@StartPeriod))
Hello!
You can try this formula
=DateDiff('d',Report.GetPeriodEndDate(@EndPeriod) , Report.GetPeriodStartDate(@StartPeriod))
Thank you very much, it worked!
I only had to change the order to =DateDiff('d',Report.GetPeriodStartDate(@StartPeriod) , Report.GetPeriodEndDate(@EndPeriod)
to obtain the result I was looking for.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.