Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to calculate the maximum date and previous date for a given system/
for calcualing max value i am using set expression
max Value vCAMaxDate=max({<[System Name]={'$(CA)'}>}Date) // this works fine
for previopus date =date(FirstWorkDate(Date(vCAMaxDate - 1),1,$(vHolidays)),'MM/DD/YYYY')
here i have an issue i have a list of holidays where i want to store it into variables because i have like 3 years of holiday date
if i replace the $(vHolidays) with dates like '03/29/2013','03/28/2013' it works fine but i f i create a variable and store the holidays list its not taking the list
so how to store the holidays in the variables and use in the previous date calculation..
Help would be really appreciated..
Hi gysbert thanks for the reply..
i created a script and loaded into the variables ..
what ever the values are loaded into the variable view works fine but the values shows as garbage error..
will this be an issue in the future..
but still it works...