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:

New public beta available (1997) raw=T is broken in [include] (1997) [format] minus figures (2003) Template Encryption (1998) WebCat2b12 - nesting [tags] (1997) WebCatalog for Postcards ? (1997) WebCat on Alpha? (1997) Error message (1999) redirect with frames (1997) send mail problem? (1997) Problem with Midnight (2003) What is WebDNA (1997) Macs and SQL (2000) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) SSL, WebSTAR, WebCatalog (1998) WCS Newbie question (1997) Fileinfo (2001) Multiple Pulldowns (1997) NT version (1997) Checkbox question (1997)