Re: [SHOWIF] PROBLEM

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27286
interpreted = N
texte = You can try using math [math show=f]datecheck={[date]}-{[enddate]}[/math] then check to see [datecheck]>0or you can think about returning records from you database whose enddate is larger than todays date[search db=file.db&geENDDATEdatarq=[date]&ENDDATEtype=date]Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 ********************************* -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Natalie M. Rezonoff Sent: Wednesday, February 09, 2000 7:21 AM To: WebCatalog Talk Subject: [SHOWIF] PROBLEM Hello. I have a database where products expire on certain date.sku title enddate 1 product1 02/02/2000 2 product2 01/08/2001I am trying to do the following:[showif [date]<[enddate]] [title] [/showif]this does not work because the showif treats the date as number and not as date, therefore, 01/08/2001 is smaller than 02/02/2000.Is there a solution for that? Thanks, Natalie------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [showif] problem (Gil Poulsen 2009)
  2. [WebDNA] [showif] problem (Lawrence 2009)
  3. Re: [SHOWIF] PROBLEM (WebDNA Support 2000)
  4. [SHOWIF] PROBLEM (Natalie M. Rezonoff 2000)
  5. Re: [SHOWIF] PROBLEM (Nitai 2000)
  6. Re: [showif] problem (Kenneth Grome 1999)
  7. Re: [showif] problem (Gil Poulsen 1999)
  8. [showif] problem (Howard Wolosky 1999)
You can try using math [math show=f]datecheck={[date]}-{[enddate]}[/math] then check to see [datecheck]>0or you can think about returning records from you database whose enddate is larger than todays date[search db=file.db&geENDDATEdatarq=[date]&ENDDATEtype=date]Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 ********************************* -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Natalie M. Rezonoff Sent: Wednesday, February 09, 2000 7:21 AM To: WebCatalog Talk Subject: [showif] PROBLEM Hello. I have a database where products expire on certain date.sku title enddate 1 product1 02/02/2000 2 product2 01/08/2001I am trying to do the following:[showif [date]<[enddate]] [title] [/showif]this does not work because the showif treats the date as number and not as date, therefore, 01/08/2001 is smaller than 02/02/2000.Is there a solution for that? Thanks, Natalie------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 WebDNA Support

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:

Help with Repost Data msg from form (1997) Hideif not working? (2001) Symantec VIsual Page 1.0.3 (1997) Is Web Merchant Necessary? (2000) Nested Loops and SHOWIFs (1997) Limiting user access to .tmpl files (1997) [WebDNA] TCPconnect and Bitcoin rate (2019) [showif] based on data from [tcpconnect][tcpsend]? (2000) Cyberstudio and WebDNA (1997) Occasional crashes with $remove (1997) [WebDNA] shopping sites and the "old commerce tags" (2012) OK, here goes... (1997) OFF-TOPIC: Free webdna.net email addresses ... (2003) How do you TEAM Code? (2004) Newbie problem blah blah blah (1997) Time to opensource? was [SMSI] WebDNA is too good to go (2006) [TaxableTotal] - not working with AOL and IE (1997) The beginning (1997) Problem with summary on date / inconsequent webcat behaviour (1998) Big Databases (1997)