Script for returning week number

[atapper]

Does anybody have a script or even a good idea on how to get the current week number? ie. this was posted during week 51.

I am hoping that my EU Macro Scheduler brethren have already solved this problem.

Thanks in advance.

[Marcus Tettmar]

VBSTART
VBEND

VBEval>datepart("ww",date()),weeknumber

[conjure]

i m trying to get the week number but i m getting
syntax error
line 5 column 6
any ideas why?i m using MS13

[hagchr]

Probably trailing spaces after VBSTART and VBEND that should not be there?

[conjure]

hehehehe thank you

[CyberCitizen]

I need a way of returning what the date would be on Sunday every week.

Eg so if I run the script today I need to know what Sunday's date would be.

[hagchr]

Hi, DayOfWeek> will give you which day it is today (Sun = 1). Today is Tue ie the weekday is 3, then you need to add 5 days (7-3+1) to today's date to get Sunday's date. Or do you need next Sunday's date given a specific date or week number?

[CyberCitizen]

I need to be able to open a file say today and know what the date is on Sunday.

I then need to be able to open it in 2 days and know the date for Sunday.

[hagchr]

Will this work?

Code: Select all

DayOfWeek>daytoday
Let>DaystoSun={7-%daytoday%+1}

GetDate>currDate
DateAdd>currDate,D,DaystoSun,strSunDate
MDL>Next Sunday: %strSunDate%