Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Just search for calendar, there are many references available
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...)
So something like this:
YTD
InYearToDate(datefield,today(), 0, 4)
PYTD
InYearToDate(datefield,today(), -1, 4)
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
Thank you Sunny, i will check and mark it as correct answer..