Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement