Forums
This topic is locked
Test for a date range Help
Posted 28 May 2001 08:51:00
1
has voted
28 May 2001 08:51:00 Ben de Groot posted:
I am trying to test a date range. I am not sure exactly the best way to achieve this. I tried this;
if strdate3 >= 1/2/02 and strdate3 <= 6/1/02 then course = "valid" end if
Obviously this example does not work, but can anyone enlighten me with the best way of testing strdate3 to see if it's not less than 1/2/02 a not greater than 6/1/01.
Ben
Replies
Replied 30 May 2001 19:00:40
30 May 2001 19:00:40 Joel Martinez replied:
if not(strdate3 <= cDate("1/2/02"
) and not(strdate3 >= cDate("6/1/01") then
...is this thing on?
) and not(strdate3 >= cDate("6/1/01") then...is this thing on?
Replied 31 May 2001 00:40:23
31 May 2001 00:40:23 Ben de Groot replied:
<font face='Verdana'>Thanks Joel It worked!</font id='Verdana'>