Fiscal YTD Variable
I need to calculate the Month to date and Year to date from my fiscal calendar, if the end date is given as a variable user input.
Eg.,
If my end date variable1 --> was 01Aug 07 and end date 2 --> 01Aug 08
Output
AUG 08 AUG 07 VAR
$400 $500 $100
Pls send me your insights!!