Re: Dates and Math - Simple Subtraction
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58889
interpreted = N
texte = Brian, Thanks. I must be misunderstanding the type=date conversion then. I guess I assumed that this instruction would identify "SOLD' as a date instead of a number? According to your notes, I was looking at it upside down. You say the type=date... > convert your parameter from a date to a number AND the SOLD value from > every record in your database from a date to a number? The short snippet here >>> [text]SOLDDATE=[math date]{[date]}-14[/math][/text] generates a 00/00/0000 value. The values that in our database are spitting out a 00/00/00 number. The numbers from our database come out with a fixed value and I'm trying to compare a set of vehicles that are sold within the last 14 days. I do not want to return vehicles that were sold farther back than 14. David On Jul 26, 2004, at 6:58 PM, Brian Fries wrote: > You cannot specify a format with the [math date] syntax. > > However, since your search specifies "SOLDtype=date", what WebDNA does > internally is convert your parameter from a date to a number AND the > SOLD value from every record in your database from a date to a number, > then compares them as numbers. So, WebDNA will be comparing numbers to > numbers as long as it understands the human-readable dates provided, > which it does in your case. > > Note that this is one reason many WebDNA developers choose to store > dates in their databases as [math]{[date]}[/math] values, rather than > as human-readable dates. Searches are faster because WebDNA doesn't > need to convert the dates to numbers. > > - brian > > On Jul 26, 2004, at 3:30 PM, David Cate wrote: > >> 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:
Brian, Thanks. I must be misunderstanding the type=date conversion then. I guess I assumed that this instruction would identify "SOLD' as a date instead of a number? According to your notes, I was looking at it upside down. You say the type=date... > convert your parameter from a date to a number AND the SOLD value from > every record in your database from a date to a number? The short snippet here >>> [text]SOLDDATE=[math date]{[date]}-14[/math][/text] generates a 00/00/0000 value. The values that in our database are spitting out a 00/00/00 number. The numbers from our database come out with a fixed value and I'm trying to compare a set of vehicles that are sold within the last 14 days. I do not want to return vehicles that were sold farther back than 14. David On Jul 26, 2004, at 6:58 PM, Brian Fries wrote: > You cannot specify a format with the [math date] syntax. > > However, since your search specifies "SOLDtype=date", what WebDNA does > internally is convert your parameter from a date to a number AND the > SOLD value from every record in your database from a date to a number, > then compares them as numbers. So, WebDNA will be comparing numbers to > numbers as long as it understands the human-readable dates provided, > which it does in your case. > > Note that this is one reason many WebDNA developers choose to store > dates in their databases as [math]{[date]}[/math] values, rather than > as human-readable dates. Searches are faster because WebDNA doesn't > need to convert the dates to numbers. > > - brian > > On Jul 26, 2004, at 3:30 PM, David Cate wrote: > >> 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:
CC Payment Processors (2007)
WebCommerce: Folder organization ? (1997)
OSX 4.5 webstar (2002)
[WebDNA] Use convertchars not grep for \n in Linux (2010)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
WebCat2b12--[searchstring] bug (1997)
Re2: frames & carts (1997)
Choke # on Emailer (2002)
problems with 2 tags shakur (1997)
Replace context problem ... (1997)
Location of Browser Info.txt file (1997)
Cancel Subscription (1996)
Document Contains No Data! (1997)
redirect from the errorsMessages.db entry (1997)
Sendmail truncation in Eudora Clients (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Re1000001: Setting up shop (1997)
Showing unopened cart (1997)
Forcing a NEWCART (1997)
Show if time tags (1997)