Re: Dates and Math - Simple Subtraction
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58885
interpreted = N
texte = I step 3), you use a variable named [THREEWEEK] - your previous steps created the [TWOWEEK] variable. You should be able to simplify this into one easy step: [text]SOLDDATE=[math date]{[date]}-14[/math][/text] The {[date]} results in a number (days since the year 0000), from which you can simply subtract 14 days. The [math date] turns that number back into a human-formatted date (using you preferences settings). - brian On Jul 26, 2004, at 2:12 PM, David Cate wrote: > Hello, > > I'm trying to only show records that exist within the past two weeks. > If an item was sold more than two weeks ago, we don't want to display > the record. > > Can someone tell me where I've gone wrong? > > 1. Define [TODAY[ > [text]TODAY=[date %m/%d/%y][/text] > (Note: Database already carries 00/00/00 value) - Number turns out fine > > 2. Define two week value > [text]TWOWEEK=[Math]{[TODAY]}-{00/14/00}[/Math][/text] > (This seems to be the problem - This turns out a number 34870 - not > sure how that happened. > > 3. Format TWO WEEK to var [SOLDDATE] > [text]SOLDDATE=[format days_to_date > %m/%d/%y][THREEWEEK][/format][/text] > (value turns out 00/00/00) > > Here's the search query...which obviously does not work. Anyone have > any suggestions for anything for me look at? > [search > db=admin/cars- > n.db&geSTOCKdata=[blank]&geSolddata=[SOLDDATE]&SOLDtype=date] > > Thanks in advance. > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I step 3), you use a variable named [THREEWEEK] - your previous steps created the [TWOWEEK] variable. You should be able to simplify this into one easy step: [text]SOLDDATE=[math date]{[date]}-14[/math][/text] The {[date]} results in a number (days since the year 0000), from which you can simply subtract 14 days. The [math date] turns that number back into a human-formatted date (using you preferences settings). - brian On Jul 26, 2004, at 2:12 PM, David Cate wrote: > Hello, > > I'm trying to only show records that exist within the past two weeks. > If an item was sold more than two weeks ago, we don't want to display > the record. > > Can someone tell me where I've gone wrong? > > 1. Define [TODAY[ > [text]TODAY=[date %m/%d/%y][/text] > (Note: Database already carries 00/00/00 value) - Number turns out fine > > 2. Define two week value > [text]TWOWEEK=[math]{[TODAY]}-{00/14/00}[/Math][/text] > (This seems to be the problem - This turns out a number 34870 - not > sure how that happened. > > 3. Format TWO WEEK to var [SOLDDATE] > [text]SOLDDATE=[format days_to_date > %m/%d/%y][THREEWEEK][/format][/text] > (value turns out 00/00/00) > > Here's the search query...which obviously does not work. Anyone have > any suggestions for anything for me look at? > [search > db=admin/cars- > n.db&geSTOCKdata=[blank]&geSolddata=[SOLDDATE]&SOLDtype=date] > > Thanks in advance. > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
default value from Lookup (was Grant, please help me) (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
two unique banners on one page (1997)
Email notification to one of multiple vendors ? (1997)
CERT Advisory on malicious scripts (2000)
Date search - yes or no (1997)
Updating checkboxes made easy !!! (1998)
wierd [cart] action! (1997)
users change an email address (2002)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
Webcat deletes last line from Excel-saved text db (2004)
Almost a there but..bye bye NetCloak (1997)
default error on NT? (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Bug or syntax error on my part? (1997)
Spiders (1998)
WebCatalog 4.0 Users that want to talk to the Media.... (2000)
PCS Frames (1997)
Re1000002: Setting up shop (1997)
weird happenings (1997)