Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get the Week Number by Month and Week
Message
From
28/08/2017 02:08:53
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01653756
Message ID:
01653798
Views:
77
>Hi,
>
>I have a function in my app that determines the week number in a year (1 to 53) based on the Month (1 to 12) and the week in the month (1 to 5). The Week in the Month is the week that has Monday (similar to the VFP function Week( tDate, 3, 2). My code works, which I wrote about 20 years ago. And I don't want to show it here since it could cause irrevocable damage to your health (while falling from the chair laughing).
>
>Therefore, I am asking, if you could create an expression or a simple function for this, I would appreciate it.
>
>TIA

Hi,

lParameter ldDate
Transform( Week(ldDate, Set('fweek'),Set('fdow')))

works for me.

Regards,
Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform