How can I achieve CurrentFullYear & CurrentFullMonth

[ishaqbaig]

Dear Rob,
How can I achieve CurrentFullYear & CurrentFullMonth
If I select YTD for 2019 need to get data from 01/01/2019 to 31/12/2019
instead of 01/0/2019 till Today()
Regards
Ishaq

[ishaqbaig]

The Above was achieved using the below variables
New Variables were created to achieve this

• vSetFULLYear - the Full Year based on the selected year/month. Not same as YTD
• vSetPreviousFULLYear – the Full LAST Year based on the selected year/month. Not LY YTD
• vSetFULLMonth - The FULL Month based on the selected month
• vSetFULLPreviousYearMonth - The FULL Month of last Year based on the selected month

//---------------------------------------------------------------------
//Gets Data from 01/01/2019 to 31/12/2019 if the selected year is 2019
//Gets Data from 01/01/2018 to 31/12/2018 if the selected year is 2018
// FULL Year of the Selected year
//---------------------------------------------------------------------
Let $(_fieldPrefix)vSetFULLYearModifier =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'$(_vClearFieldList)
$(_f_MonthSerial) = {"<=@(=$(_qvctemp.vMaxModifier)$(_f_MonthSerial)))"},
$(_fYear) = {"@(=$(_qvctemp.vMaxModifier)$(_fYear)))"}'
);

Let $(_fieldPrefix)vSetFULLYear =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'{$<
@($(_fieldPrefix)vSetFULLYearModifier)

}'
);

//---------------------------------------------------------------------
//Gets Data from 01/01/2018 to 31/12/2018 if the selected year is 2019
// FULL Previous Year of the Selected year
//---------------------------------------------------------------------
Let $(_fieldPrefix)vSetPreviousFULLYearModifier =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'$(_vClearFieldList)
$(_f_MonthSerial) = {"&lt;=@(=$(_qvctemp.vMaxModifier)$(_f_MonthSerial))-12)"},
$(_fYear) = {"@(=$(_qvctemp.vMaxModifier)$(_fYear))-1)"}'
);

Let $(_fieldPrefix)vSetPreviousFULLYear =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'{$<
@($(_fieldPrefix)vSetPreviousFULLYearModifier)

}'
);

//---------------------------------------------------------------------
// Gets data from 01/12/2019 to 31/12/2019 if the selected month is Dec-19
// Whereas MTD gives data from 01/12/2019 to 19/12/2019 (if today is 19/12/2019)
// Full Month Total of the selected month
//---------------------------------------------------------------------
Let $(_fieldPrefix)vSetFULLMonthModifier =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'$(_vClearFieldList)
$(_f_MonthSerial) = {@(=$(_qvctemp.vMaxModifier) $(_f_MonthSerial)))}'
);

Let $(_fieldPrefix)vSetFULLMonth =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'{$<
@($(_fieldPrefix)vSetFULLMonthModifier)

}'
);

//---------------------------------------------------------------------
// Gets data from 01/12/2018 to 31/12/2018 if the selected month is Dec-19
// Whereas Last Year MTD gives data from 01/12/2018 to 19/12/2018 (if today is 19/12/2019)
// Full Month Previous Year Month
//---------------------------------------------------------------------
Let $(_fieldPrefix)vSetFULLPreviousYearMonthModifier =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'$(_vClearFieldList)
$(_f_MonthSerial) = {@(=$(_qvctemp.vMaxModifier) $(_f_MonthSerial))-12)}'
);

Let $(_fieldPrefix)vSetFULLPreviousYearMonth =
MapSubString('_qvctemp.Calendar.EscapeCharsMap',
'{$<
@($(_fieldPrefix)vSetFULLPreviousYearMonthModifier)

}'
);