calculation of working days

[shree909]

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

[Gysbert_Wassenaar]

vHolidays needs to be either comma separated list of strings in the right date format or a comma separated list of numeric dates. The latter is often easier to use. See here or here for example.

[shree909]

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