>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,