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
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
Retrieving data ...