Assign a number to a week day

[evr72]

Hello,

I am trying to assign a number to the weeks and for the different days from Monday to Friday, then add both numbers

Here is what I have tried so far but no luck

WeekNumber = DatePart("ww", Date, 2, vbFirstFourDays)
Response.Write(WeekNumber)


weekNumber23 = WeekDayName(WeekDay(Date))
if weekNumber23= "Wednesday" then response.write(1)

end if

 

[ChrisHirst]

Weekdays already have numbers.

http://www.devguru.com/technologies/vbscript/13987.asp

And why not simply use 'ww' as a DatePart parameter?

http://www.devguru.com/technologies/vbscript/13916.asp

or

http://technet.microsoft.com/en-us/library/ee198903.aspx

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[xwb]

Not sure if this is what you are after. If you copy the code into a .vbs file and run it from the cmd prompt, it will be a lot easier to debug

WeekNumber = DatePart("ww", Date, vbMonday, vbFirstFourDays)
WScript.echo WeekNumber
DayNumber  = DatePart("w", Date, vbSunday, vbFirstFourDays)
WScript.echo DayNumber

WScript.echo WeekNumber * 5 + DayNumber

Then when you've got it right, change the WScript.echo to Response.Write and and put it in your web form