>>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
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
