Skip to main content

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)

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.


You are welcome! :)


Reply