Re: Showif date range comparison

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24070
interpreted = N
texte = John: I tried your suggestion but still can't get a comparison. It may be that my Shipdate variable is defined as a date and the week1 variable as a number. How do I compare the two? Ben[showif [Shipdate]>[week1]][Minutes][/showif]---------- >From: John Jakovich >To: WebDNA-Talk@smithmicro.com >Subject: Re: Showif date range comparison >Date: Wed, Feb 24, 1999, 5:41 PM >> >> >> [math date] week1={01/01/1999}[/math] >> [format days_to_date %m/%d/%Y][math] >>week2=[week1]+7[/math][/format] >>(and so on) >> >> >> [showif [Shipdate]ge[week1]][Minutes][/showif] > > > > Hello, I have not tested your code but right away I can tell you that you > need to insert a > for ge. > > [showif [Shipdate]>[week1]][Minutes][/showif] > > In a showif context you can use the < and > signs. Try that and see if > your search works out better. For more info on allowable stuff in a > [showif] look here: > http://207.67.226.106/WebCatalog/WebCatReference/ShowIfContext.html. > Good luck. > > > John Jakovich/Support Assistant | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ > > > Associated Messages, from the most recent to the oldest:

    
  1. Re: Showif date range comparison (Kenneth Grome 1999)
  2. Re: Showif date range comparison (es-sleestak 1999)
  3. Re: Showif date range comparison (Ben Weinberg 1999)
  4. Re: Showif date range comparison (Kenneth Grome 1999)
  5. Re: Showif date range comparison (Ben Weinberg 1999)
  6. Re: Showif date range comparison (John Jakovich 1999)
  7. Showif date range comparison (Ben Weinberg 1999)
John: I tried your suggestion but still can't get a comparison. It may be that my Shipdate variable is defined as a date and the week1 variable as a number. How do I compare the two? Ben[showif [Shipdate]>[week1]][Minutes][/showif]---------- >From: John Jakovich >To: WebDNA-Talk@smithmicro.com >Subject: Re: Showif date range comparison >Date: Wed, Feb 24, 1999, 5:41 PM >> >> >> [math date] week1={01/01/1999}[/math] >> [format days_to_date %m/%d/%Y][math] >>week2=[week1]+7[/math][/format] >>(and so on) >> >> >> [showif [Shipdate]ge[week1]][Minutes][/showif] > > > > Hello, I have not tested your code but right away I can tell you that you > need to insert a > for ge. > > [showif [Shipdate]>[week1]][Minutes][/showif] > > In a showif context you can use the < and > signs. Try that and see if > your search works out better. For more info on allowable stuff in a > [showif] look here: > http://207.67.226.106/WebCatalog/WebCatReference/ShowIfContext.html. > Good luck. > > > John Jakovich/Support Assistant | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ > > > Ben Weinberg

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:

Is the list server working? (1998) New (1998) WC 2.0 frames feature (1997) Restart of DBserver (1997) [shipCost] math formula? (1997) CSS (2001) Another webcatalog site!! (1997) Using EIMS instead of Emailer (1998) [searchString] (1997) Starting WebCat under linux (2000) [Sum] function? (1997) problems with 2 tags (1997) question: webmerchant connection (1997) REPLACE and/or APPEND (2002) New Command prefs ... (1997) Date fun with MySQL (2004) Extended [ConvertChars] (1997) suffix mapping for NT? (1997) X etc.... (1999) [append] (1997)