Week of the month, day of the week problem

[Durango122]

Hi folks
ms sql
cr 9.0
I have these date and would like to pass them to my variable
-------------------------------------------------------
New Year's Day Monday, January 1 this does not change
------------------------------------------------
Martin Luther King, Jr. Day Monday, January 15
<b>always the second monday of january</b>
-------------------------------------
President's Day Monday, February 19
<b>always the second monday of february</b>
-----------------------------------------
Good Friday Friday, April 6
<b>always the first friday of april</b>
--------------------------------------
Memorial Day Monday, May 28
<b>always the last monday of may</b>
---------------------------------------
Independence Day Wednesday, July 4
that does not change
----------------------------------------
Labor Day Monday, September 3
<b>always the first monday of september</b>
---------------------------------------
Thanksgiving Day Thursday, November 22
<b>always the third thursday of november</b>
-----------------------------------------
Christmas Day Tuesday, December 25
that does not change
----------------------------------------------
How can i insert these in my variable as shown below
i would like to be able to get like week of the month and day of the week instead having the hard code value
i have and {?End_Date} parameter i used for the year
------------------------------------------------

BeforeReadingRecords;
DateVar Array Holidays := [
Date (year({?End_Date}),1,1),
Date (year({?End_Date}),1,15),
Date (year({?End_Date}),2,19),
Date (year({?End_Date}),4,6),
Date (year({?End_Date}),5,28),
Date (year({?End_Date}),7,4),
Date (year({?End_Date}),9,3),
Date (year({?End_Date}),11,22),
Date (year({?End_Date}),12,25)
];
0

---------------------------------------------
Thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Durango122]

Nobody can help me :-(

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[Durango122]

got it gigure out
used kens formila and modified it to work
thanks Ken was worth the money to get your books


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40