Thanks for the extra pair of eyes. Looks like I have it right but still can’t type to good while looking at another screen.
<@Calc EXPR='<@TSTOSECS TS="<@CURRENTTIMESTAMP>" >-2700'>
Logic is right? This will find everything that is older than 45 minutes right?
on 8/29/03 9:42, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
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] <mailto:[EMAIL PROTECTED]> >
To: <[EMAIL PROTECTED] <mailto:[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] <mailto:[EMAIL PROTECTED]>
> www.dss-db.com <http://www.dss-db.com>
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf <http://www.witango.com/maillist.taf>
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
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
