how can I cast a Date in "ww" format to an integer

[pungentSapling]

I want to populate a 2d array using data from a query. The first set of data for the array are dates in "ww" format......problem is that I want the array to be an Integer datatype. I guess the dates are variant data type.
Any one know how to change the dates to ints?

any help would be greatly appreciated.

 

[Mile-O]

Int(YourDateHere)

 

[pungentSapling]

fantastic! I knew it had to me simple but could not find it in help.

Thanks!