Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get the Week Number by Month and Week
Message
De
28/08/2017 02:08:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01653756
Message ID:
01653798
Vues:
76
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform