Skip to Content

Year To Date Calculation

Hi Guys,

I am writing a report which counts activity in a time period (time period specified by user, Datefrom and DateTo).

I can total the different activities in that time period, however I am struggling to count the total for the year to date, up until the DateTo parameter for the different activities. What I need to do is to calculate from the prior 1st April to the DateTo parameter.

Any guidance would be hugely appreciated.

Many Thanks

OAP

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 14, 2016 at 02:01 PM

    Hi OAP,

    When you say 'prior' 1st April, do you mean previous year's 1st April (where the current year is determined by the DateFrom prompt) up until the DateTo prompt's date?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded