Dan, missing some quotes and a error. 45 minutes is fine (2700/60 = 45)
 
Basket.timeSeconds<=<@CALC EXPR='<@TSTOSECS TS="<@CURREN%TTIMESTAMP>">-2700> (your's)

Basket.timeSeconds<=<@<@CALC EXPR='<@TSTOSECS TS="<@CURRENTTIMESTAMP>">-2700'>

regards

Daniel

----- Original Message -----
From: "Dan Stein" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 2:49 PM
Subject: Witango-Talk: Another pair of eyes

> I could use another pair of eyes to confirm that this _expression_ evaluates
> to 45 minutes.
>
> In other words this should find everything in the basket where the column
> timeseconds is <= 45 minutes from now. Or another way to say it everything
> that has been sitting in the basket for 45 minutes or longer.
>
> This is the criteria in the search action:
>
> Basket.paid=0
> and
> Basket.timeSeconds<=<@CALC EXPR='<@TSTOSECS TS="<@CURREN%TTIMESTAMP>">-2700>
>
> Just wanted to make sure I have syntax correct and the logic right.
> --
> Dan Stein
> Digital Software Solutions
> 799 Evergreen Circle
> Telford PA 18969
> Land: 215-799-0192
> Mobile: 610-256-2843
> Fax 413-410-9682
> FMP, WiTango, EDI,SQL 2000
>
[EMAIL PROTECTED]
> www.dss-db.com
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: Go to
http://www.witango.com/maillist.taf
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

Reply via email to