What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Dates and Math - Simple Subtraction

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58883
interpreted = N
texte = 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. ------------------------------------------------------------- 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:

    
  1. Re: Dates and Math - Simple Subtraction ( Brian Fries 2004)
  2. Re: Dates and Math - Simple Subtraction ( David Cate 2004)
  3. Re: Dates and Math - Simple Subtraction ( "Gary Krockover" 2004)
  4. Re: Dates and Math - Simple Subtraction ( Brian Fries 2004)
  5. Re: Dates and Math - Simple Subtraction ( David Cate 2004)
  6. Re: Dates and Math - Simple Subtraction ( Brian Fries 2004)
  7. Dates and Math - Simple Subtraction ( David Cate 2004)
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. ------------------------------------------------------------- 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:

Showif, Hideif reverse logic ? (1997) Store Admin Problems (1999) Re1000001: Setting up shop (1997) Nested tags count question (1997) WebCat2b15MacPlugin - [protect] (1997) Help! WebCat2 bug (1997) eMail volume (2000) is there a global includes directory? (1998) Just testing (2003) Nesting format tags (1997) Email within tmpl ? (1997) charging? (2001) WebCat editing, SiteGuard & SiteEdit (1997) [WebDNA] Store module/site (2012) Sorting nested search (2003) Search Command, multiple dbs, etc. (2000) [date format] w/in sendmail (1997) shownext & math (1997) New WebDNA Solutions ... (1997) Public Beta for WebCatalog 4.0 is Available (2000)