Duh, Had the greater and less reversed. Thanks Scott for pointing it out.
Since I usually say it as Is today less than... But I wrote it the other way I kept checking it and seeing it backwards. Feeling pretty foolish. Dan on 7/15/03 16:36, Dan Stein at [EMAIL PROTECTED] wrote: > This keeps resulting in no discount even though the current date is between > the start and end date. > > Where is my mistake? > > <@IF EXPR='<@DATETOSECS DATE='<@VAR NAME="user$discountStart" > FORMAT="DATETIME:%m/%d/%Y">'>><@DATETOSECS DATE="<@CURRENTDATE>" > && > <@DATETOSECS DATE='<@VAR NAME="user$discountEnd" > FORMAT="DATETIME:%m/%d/%Y">'><<@DATETOSECS DATE="<@CURRENTDATE>" >'> > > Discount > > <@ELSE> > > No Discount > > </@IF> -- 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
