search for: stopdat

...hieve is that some actions like forwarding or vacation messages are performed from a certain date untill another date. Which would allow a user to define a timeperiod in which the autoreply or forward should be done and automatically stop without updating the sieve script again. Comparing start and stopdate is cake, but just getting today's date seems to be a hassle, any ideas? regards, bart

...efix=SUBSTRING('00497720954992',1,length(dialprefix)) OR dialprefix='defaultprefix') AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5) AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5) AND sunday='1' AND idtariffgroup='1' AND ( cc_tariffplan.dnidprefix LIKE '192.168.0.36%' OR (cc_tariffplan.dnidprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefi...

...efix=SUBSTRING('00497720954992',1,length(dialprefix)) OR dialprefix='defaultprefix') AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5) AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5) AND sunday='1' AND idtariffgroup='1' AND ( cc_tariffplan.dnidprefix LIKE '192.168.0.36%' OR (cc_tariffplan.dnidprefix='all' AND 0 = 0)) ORDER BY LENGTH(dialprefi...

...ot;1996-01-01" "1996-01-01" "1997-01-01" "1998-01-01" [6] "1999-01-01" "2000-01-01" "2001-01-01" "2002-01-01" "2003-01-01" [11] "2004-01-01" "2005-01-01" > TimeSpan<-as.integer(difftime(StopDate,StartDate)) Warning message: NAs introduced by coercion # Note: NAs correspond to 3 invalid dates, apparently typos > h<-hist(StartDate[TimeSpan>0 & StartDate>years[1]], breaks=years, freq=T, + main="",xlab="",ylab="number of sites", col=&quot...