Find if specific date exsit in a week range

[vituja]

Hi All,

I need to check to see if the beginning of a new year is within this weekrange. If so then do something.

I have a field (weekrange) that contains "12/29/2003 - 01/05/2004" (changes each week automatically).

In the example above 01/01/2004 exists within this weekrange
but I need to identify that it does.

How would I go about this. If it was SQL I would use something like:
...where convert(datetime,@DTE) between convert datetime,substring((select weekrange from Inserted),1,10))
and
convert(datetime,substring((select weekrange from Inserted),14,10))and netid=@netid and
weekrange=(select weekrange from Inserted))

But how would I go about this in VBScript? Any help would be appreciated. Thanks.

 

[SarkMan]

You could try something like this

dim sDate
sDate="12/29/2003 - 01/05/2003"
dim arrDate
arrDate=split(sDate," - &quot
sdate1=cdate(arrDate(0))
sDate2=cdate(arrDate(1))
if (year(sDate1) <> year(sDate2) ) then
msgbox &quot;Year has changed&quot;
else
msgbox &quot;Year has not changed&quot;
end if