Re: Dates and Math - Simple Subtraction
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58886
interpreted = N
texte = Oh yes! I saw that before I sent it, but still didn't work. I do like the simple step, but what if I'm searching for a six character date? 00/00/00 Can I use the format with the [math date] i.e. [math date format=%m/%d/%y] Thanks for taking time out with a hack to help... David On Jul 26, 2004, at 5:58 PM, Brian Fries wrote: > 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/ > ------------------------------------------------------------- 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:
Oh yes! I saw that before I sent it, but still didn't work. I do like the simple step, but what if I'm searching for a six character date? 00/00/00 Can I use the format with the [math date] i.e. [math date format=%m/%d/%y] Thanks for taking time out with a hack to help... David On Jul 26, 2004, at 5:58 PM, Brian Fries wrote: > 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/ > ------------------------------------------------------------- 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/
David Cate
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:
Using Currencies other than Dollars (1997)
Merging databases (1997)
WebCat2 - storing unformatted date data? (1997)
Stopping bad HTML propagation ? (1997)
Rams SuperBowl Champs (2000)
Dark Horse Comics success story (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Parameter Problem ATTN: Ken Grome (1998)
catagories (1997)
Emailer problem (1998)
[OT] Mozilla | Was: R.I.P. Netscape (2003)
[WebDNA] TLS 1.2 and [tcpconnect] (2018)
Mac & Internet Explorer (2000)
an easy one... (2000)
WC2b12: Yes, Formulas.db is for real (1997)
2nd try: possible to weight results of grouped fields search? (1998)
AAgghh!! Help, please. SSL strikes again. (1997)
[delete] problem (1997)
Protecting databases (1999)
WebCat2.0 [format thousands .0f] no go (1997)