Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A date from Week and Year?
Message
From
26/11/1999 10:51:22
 
 
To
26/11/1999 07:31:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00295675
Message ID:
00295729
Views:
19
>Hello,
>I have two values, the Week (like 48 for today) and the year (1999).
>How can I get the date of the first day of this week?
>So it should give me the date of last Sunday.
>I did not find any function for this.

lnWeek = 48
lnYear = 1999
?(DATE(lnYear,1,1) + (lnWeek-1) * 7) - DOW(DATE(lnYear,1,1) + (lnWeek-1) * 7) + 1
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform