AnsweredAssumed Answered

Current year week number from now()

Question asked by VRFuser on Feb 17, 1999
hi,

try this formula:

weeknumber = integerpart(((month -1)*30.5 + day) / 7 ) + 0.99)

example weeknumber = integerpart(((2-1)*30.5 + 18) /7) +0.99) = 7



> -----Original Message-----
> From: Strutt, Michael [mailto:mstrutt@amp.com]
> Sent: Thursday, February 18, 1999 1:14 PM
> To: Vee User (E-mail)
> Subject: Current year week number from now()
>
>
> It looked easy when I stared!!!
> But I need a user function that will output current year/week no from
> now().
> Friday 23rd of April is week 16
> 1999 4 23 = week 16
> Any ideas???
> Regards Mike
>
> Phone +44 (0)1908 221344         M/A-COM Ltd 
> Fax     +44 (0)1908 221366         Featherstone Road
> mstrutt@amp.com                       Wolverton Mill
> Principal Test Engineer                Milton Keynes
>                                                  MK12 5EW
> A little learning is a dangerous thing.
> Drink deep, or taste not the Pierian spring.
> (Alexander Pope 1688-1744)
>
>
>

Outcomes