Financial YTD Calculation

[sridhar_sigired]

Hi,

Inyeartodate function works for calendar year dates

Ex: Inyeartodate(datefield,today(),0)

      Jan1st to today

Can anyone help me to get below dates

YTD - Apr1st to Today

PYTD - Apr1st 2015 to Nov16th 2015.

[vinieme12]

Just search for calendar, there are many references available

Fiscal Year

[sunny_talwar]

You can provide the first_month_of_the_year as an input (https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/i...)

[sunny_talwar]

So something like this:

YTD

InYearToDate(datefield,today(), 0, 4)

PYTD

InYearToDate(datefield,today(), -1, 4)

[shraddha_g]

In your syntax,  inyeartodate(datefield, today(), 0,4)

For current YTD starting from Apr

And

Inyeartodate(datefield, today(), - 1,4) for prev year YTD starting from Apr

[sridhar_sigired]

Thank you Sunny, i will check and mark it as correct answer..