General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only