Do we have MTD and YTD functions?

[laxmanqlik]

Hi Everyone,

can any one let me know that do we have MTD (Month to date) and YTD (Year to Date) Functions existed .

if yes please let me know the way to use them.

thanks in advance

[marcus_sommer]

Such functions aren't available. You need to use set analysis and/or flags within the script for it. Here are two examples how it could be developed/used:

Previous YTQ, QTD, MTD and WTD

Calendar with flags making set analysis so very simple

- Marcus