>In VFP there is a week() function that allows you to pass it a date and it returns the week number. Has anyone written or does anyone know of such a function that can be used in FP2.6? I don't have premiere membership yet so I can't search the files section. Can anyone help ?
>
>TIA
Hi Simon,
The answer to this depends on how you define "week number", but I'd start by doing something like:
ldJan1 = CTOD("1/1/" + TRANSFORM(YEAR(DATE()), "####"))
lnweek = (DATE() - ldJan1) / 7
Now if you want to bump any remainer up, look at the CEILING() function.
hth,
George
Ubi caritas et amor, deus ibi est