Convertproblems 
Author Message
 Convertproblems
Hi!
The problem is that i want to convert YYWW to YYYY-MM-DD.
That is for example  99(year) 01(week) to 1999-01-01.
I really need some help with this problem.

Thanks Jan



Tue, 06 Nov 2001 03:00:00 GMT
 Convertproblems

Function FromWeekToDate(ByVal WeekDate as String) as Date
   'WeekDate => "YYWW"
   FromWeekToDate = DateSerial(Left(WeekDate, 2), 1, Mid(WeekDate, 3) * 7 - 6)
End Function


Wed, 07 Nov 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Convertproblem


 
Powered by phpBB® Forum Software