What is the difference between Inyear and Inyeartodate.

[retko1985]

Thanks

[sunny_talwar · Accepted solution]

Try these two expression

=InYear(MakeDate(2018, 12, 31), Today(),0)

=InYearToDate(MakeDate(2018, 12, 31), Today(),0)

Since, 31st Dec 2018 is in 2018, it will show as -1 (TRUE) for InYear, but it is not between year start and today, it will show 0 for InYearToDate

[jolivares]

Tomorrow is true for InYear, but not for InYearToDate.  Likewise, Today() is true for both.

[Anonymous]

Hi,

Please see: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFun...

and

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFun...