For some odd reason i can't seem to compare dates with operators less than or equal to etc.

See line of code below:

dim offCycleEndDate

If Date < 14 / 2 / 2008 Then
If Date > 30 / 1 / 2008 Then
offCycleEndDate = "717"
End If
End If


Even though todays date is the 13th it still doesn't go through the IF statemnet.

Help someone?

You shouldn't do that anyway.

You should use DateDiff function instead.

I don't know anything about vb, but is that unquoted string seriously the format you can use for a date comparison?

and if your intention is definitely to find dates between 30/01/08 and 14/2/08 wouldn't you just use a single if statement?

cool thx, using the Datediff function now

Dear world,

Please let VBScript die already.

TIA,

Us.

my tips for dates.

always use iso 8601 yyyy-mm-dd. saves alot of headaches if you use sql server.

I don't know anything about vb, but is that unquoted string seriously the format you can use for a date comparison?

use #2008/01/02#