Re: Date Comparison

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47518
interpreted = N
texte = [if (({[date]} >= {[startdate]}) && ({[date]} <= {[enddate]}))] [then] Success [/then] [else] Failed [/else] [/if]Not tested but should work.On Thursday, February 6, 2003, at 11:43 PM, Paul Berman wrote:> Hi > > I am trying unsucessfully to compare the current date 6/2/2003 with the > start and end dates of an offer > > my start and end date format is the same as the current date but for > some > reason I just cant get this working, I have searched the archives but > found > little to help me there. > > My fields are Startdate and enddate and all I need is to endsure that > the > current date is equal or after the start date and the current date is > either > before or equal to the end date. > > Any help appreciated > > Thanks > paul > ----- Original Message ----- > From: Dan Strong > To: WebDNA Talk > Sent: Thursday, February 06, 2003 11:53 PM > Subject: Re: WebDNA Book? > > >> Ah ha. thanks... and to think I've been a 'dummy' for so long ;) >> -Dan >> >> On Thu, 6 Feb 2003 17:51:30 >> Charles Kline wrote: >>> wrox does a series of books called programmer to programmer - pretty >>> good > books. >>> >>> http://www.wrox.com/ >>> >>> - Charles >>> >>> On Thursday, February 6, 2003, at 05:49 PM, Dan Strong wrote: >>> >>>> What is 'wrox'? >>>> -Dan >>>> >>>> On Thu, 6 Feb 2003 17:46:34 >>>> Charles Kline wrote: >>>>> or maybe wrox? i would be willing to work on this project if we got >>>>> some funding. >>>>> >>>>> - ck >>>>> >>>>> On Thursday, February 6, 2003, at 05:15 PM, Dan Strong wrote: >>>>> >>>>>> Brian, >>>>>> >>>>>> Hmmmm.... not happy to hear you're having such a hard time with >>>>>> it. >>>>>> While I wholeheartedly agree that at the current time, a 'WebDNA >>>>>> for >>>>>> Dummies' book might not find a large enough audience to feed the >>>>>> author(s), my thoughts were more along the lines of a 'build it >>>>>> and >>>>>> they will come' approach, hopefully with the blessing/funding of >>>>>> SM >>>>>> and/or the '...for Dummies' folks (IDG Books Worldwide?). >>>>>> >>>>>> A bona-fide 'how-to' book on WebDNA (particularly one that could >>>>>> share in the popularity and distribution channels of an existing >>>>>> brand (i.e. '...for Dummies')) would absolutely drive consumer >>>>>> interest in the product by the simple fact that it exists. If I >>>>>> wasn't familiar with WebDNA and I was wandering through the >>>>>> Dummies >>>>>> section in Borders Books (like I do from time to time -- I own >>>>>> Javascript and DOS for Dummies and I use them both all the time.. >>>>>> and I can remember picking up VRML for Dummies back in 1998...) >>>>>> and >>>>>> I saw WebDNA for Dummies -- A Reference for the Rest of Us! -- >>>>>> The >>>>>> Fun and Easy Way to Create Attractive, Effective Web Applications >>>>>> ... or whatever... I would DEFINITELY pick it up, and most likely >>>>>> buy it, if I was interested in webdev (which I am). Maybe even >>>>>> include a CD with the Developer Edition installers for each >>>>>> platform >>>>>> as well as the Onbline Command Reference (betadoc), and links to >>>>>> SM's website, etc. etc. >>>>>> >>>>>> But of course, maybe SM isn't interested in making more $$ ;) Why >>>>>> don't I write it? Maybe I will, maybe I will..... but I definitely >>>>>> couldn't do it alone, as I feel my current WebDNA skill level is >>>>>> 'Advanced Intermediate' (some might beg to differ...). I would >>>>>> need >>>>>> a WebDNA knowledgeable editor... >>>>>> >>>>>> Anyway, this is my $0.02.... enough daydreaming for me... I took a >>>>>> look at the Forbes List of the Richest People in America this >>>>>> morning and noticed that my name wasn't on it -- I'd better get >>>>>> back >>>>>> to work. ;) >>>>>> >>>>>> -Dan >>>>>> ------------------------------------------------------------ >>>>>> http://www.StrongGraphicDesign.com >>>>>> (208) 319-0137 | Toll-free p/f 877-561-1656 >>>>>> ------------------------------------------------------------ >>>>>> >>>>>> >>>>>> >>>>>> On Thu, 6 Feb 2003 15:59:10 >>>>>> Brian B. Burton wrote: >>>>>>> Actually, I think you'd be wrong :( >>>>>>> >>>>>>> I have written part of a book, but the response to date has been >>>>>>> underwhelming. I guess it's kind of like being a shareware >>>>>>> author, >>>>>>> everybody uses shareware. 2-5% of people pay for shareware. >>>>>>> >>>>>>> The time investment in writing in a clear and concise manner, >>>>>>> along >>>>>>> with the experience needed to write such a guide makes to limited >>>>>>> to a few people in this group. I'm not saying that to be >>>>>>> arrogant, >>>>>>> but it is an accurate and true statement. On top of that, you >>>>>>> have >>>>>>> to figure out how many copies you can sell to recoup your >>>>>>> investment of time. I estimate I could sell less then 100 copies. >>>>>>> Some people think they know everything, some people wouldn't >>>>>>> spend >>>>>>> the money (I estimate it would have to be about $99 for a PDF to >>>>>>> even get close to break even vs. selling the same time being a >>>>>>> programmer), and some people will share, thus depriving yours >>>>>>> truly >>>>>>> of funds needed to eat lunch, and I've already done the starving >>>>>>> artist part of my life... >>>>>>> >>>>>>> But for all of that pessimism, I am still plodding along on my >>>>>>> book, adding and incrementing it. I'm up to about twice the >>>>>>> content >>>>>>> and am just beginning the e-commerce functionality info now. I >>>>>>> just >>>>>>> don't have the new content online anywhere at this time. >>>>>>> >>>>>>> >>>>>>> If you'd like to see what is public, please visit: http:// >>>>>>> webdna.burtons.com >>>>>>> >>>>>>> >>>>>>> Brian B. Burton >>>>>>> Burton Logistics >>>>>>> 973-263-3036 973-296-6862 (cell) >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Thursday, February 6, 2003, at 01:28 PM, Dan Strong wrote: >>>>>>> >>>>>>>> Agreed. a 'WebDNA for Dummies' book, might make somebody rich... >>>>>>>> Otherwise, Marc, yes, this list and it's archive are excellent >>>>>>>> resources. >>>>>>>> >>>>>>>> >>>>>>>> On Thu, 6 Feb 2003 10:06:25 -0800 >>>>>>>> Sales wrote: >>>>>>>>> Are there any books out there for learning WebDNA? I'm sorry, >>>>>>>>> but I've found the documentation sorely lacking for beginners, >>>>>>>>> especially with the new XML styled syntax. I did a search on >>>>>>>>> Amazon, but found nothing. >>>>>>>>> >>>>>>>>> If there aren't any books available, how have others learned >>>>>>>>> this >>>>>>>>> language? Trial and error? The documentation? This list? >>>>>>>>> >>>>>>>>> I realize this list is an excellent resource, but it would be >>>>>>>>> nice to have a good tutorial in hand. >>>> >>>> ------------------------------------------------------------- >>>> 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/ >> >> ------------------------------------------------------------ >> http://www.StrongGraphicDesign.com >> (208) 319-0137 | Toll-free p/f 877-561-1656 >> ------------------------------------------------------------ >> >> ------------------------------------------------------------- >> 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/ > ------------------------------------------------------------- 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. date comparison demo page ( Terry Wilson 2004)
  2. Re: Date comparison using showif (Robert Wade 2003)
  3. Re: Date comparison using showif (WebDna @ 2003)
  4. Re: Date comparison using showif (Brian Fries 2003)
  5. Re: Date comparison using showif (Dale's Stuff 2003)
  6. Re: Date comparison using showif (WebDna @ 2003)
  7. Re: Date comparison using showif (Donovan home EHG 2003)
  8. Re: Date comparison using showif (WebDna @ 2003)
  9. Re: Date comparison using showif (Donovan home EHG 2003)
  10. Re: Date comparison using showif (Donovan home EHG 2003)
  11. Re: Date comparison using showif (WebDna @ 2003)
  12. Date comparison using showif (Robert Wade 2003)
  13. Re: Date Comparison (Kenneth Grome 2003)
  14. Re: Date Comparison (without mistake) (Charles Kline 2003)
  15. Re: Date Comparison (Charles Kline 2003)
  16. Re: Date Comparison (Paul Berman 2003)
  17. Re: Searching by Date Comparison (John Butler 2000)
  18. Re: Searching by Date Comparison (Kim Ingram 2000)
  19. Re: Searching by Date Comparison (Jason Sofonia 2000)
  20. Searching by Date Comparison (Kim Ingram 2000)
  21. Re: Date Comparison (PCS Technical Support 1998)
  22. Re: Date Comparison (Kenneth Grome 1998)
  23. Date Comparison (Daniel Rogers 1998)
  24. Date comparison has serious bug ... (Kenneth Grome 1998)
  25. Date comparison (I think) has bugs ... (Kenneth Grome 1998)
  26. Re: webcat2b12 CGI -- Date comparisons (Kenneth Grome 1997)
  27. webcat2b12 CGI -- Date comparisons (Grant Hulbert 1997)
[if (({[date]} >= {[startdate]}) && ({[date]} <= {[enddate]}))] [then] Success [/then] [else] Failed [/else] [/if]Not tested but should work.On Thursday, February 6, 2003, at 11:43 PM, Paul Berman wrote:> Hi > > I am trying unsucessfully to compare the current date 6/2/2003 with the > start and end dates of an offer > > my start and end date format is the same as the current date but for > some > reason I just cant get this working, I have searched the archives but > found > little to help me there. > > My fields are Startdate and enddate and all I need is to endsure that > the > current date is equal or after the start date and the current date is > either > before or equal to the end date. > > Any help appreciated > > Thanks > paul > ----- Original Message ----- > From: Dan Strong > To: WebDNA Talk > Sent: Thursday, February 06, 2003 11:53 PM > Subject: Re: WebDNA Book? > > >> Ah ha. thanks... and to think I've been a 'dummy' for so long ;) >> -Dan >> >> On Thu, 6 Feb 2003 17:51:30 >> Charles Kline wrote: >>> wrox does a series of books called programmer to programmer - pretty >>> good > books. >>> >>> http://www.wrox.com/ >>> >>> - Charles >>> >>> On Thursday, February 6, 2003, at 05:49 PM, Dan Strong wrote: >>> >>>> What is 'wrox'? >>>> -Dan >>>> >>>> On Thu, 6 Feb 2003 17:46:34 >>>> Charles Kline wrote: >>>>> or maybe wrox? i would be willing to work on this project if we got >>>>> some funding. >>>>> >>>>> - ck >>>>> >>>>> On Thursday, February 6, 2003, at 05:15 PM, Dan Strong wrote: >>>>> >>>>>> Brian, >>>>>> >>>>>> Hmmmm.... not happy to hear you're having such a hard time with >>>>>> it. >>>>>> While I wholeheartedly agree that at the current time, a 'WebDNA >>>>>> for >>>>>> Dummies' book might not find a large enough audience to feed the >>>>>> author(s), my thoughts were more along the lines of a 'build it >>>>>> and >>>>>> they will come' approach, hopefully with the blessing/funding of >>>>>> SM >>>>>> and/or the '...for Dummies' folks (IDG Books Worldwide?). >>>>>> >>>>>> A bona-fide 'how-to' book on WebDNA (particularly one that could >>>>>> share in the popularity and distribution channels of an existing >>>>>> brand (i.e. '...for Dummies')) would absolutely drive consumer >>>>>> interest in the product by the simple fact that it exists. If I >>>>>> wasn't familiar with WebDNA and I was wandering through the >>>>>> Dummies >>>>>> section in Borders Books (like I do from time to time -- I own >>>>>> Javascript and DOS for Dummies and I use them both all the time.. >>>>>> and I can remember picking up VRML for Dummies back in 1998...) >>>>>> and >>>>>> I saw WebDNA for Dummies -- A Reference for the Rest of Us! -- >>>>>> The >>>>>> Fun and Easy Way to Create Attractive, Effective Web Applications >>>>>> ... or whatever... I would DEFINITELY pick it up, and most likely >>>>>> buy it, if I was interested in webdev (which I am). Maybe even >>>>>> include a CD with the Developer Edition installers for each >>>>>> platform >>>>>> as well as the Onbline Command Reference (betadoc), and links to >>>>>> SM's website, etc. etc. >>>>>> >>>>>> But of course, maybe SM isn't interested in making more $$ ;) Why >>>>>> don't I write it? Maybe I will, maybe I will..... but I definitely >>>>>> couldn't do it alone, as I feel my current WebDNA skill level is >>>>>> 'Advanced Intermediate' (some might beg to differ...). I would >>>>>> need >>>>>> a WebDNA knowledgeable editor... >>>>>> >>>>>> Anyway, this is my $0.02.... enough daydreaming for me... I took a >>>>>> look at the Forbes List of the Richest People in America this >>>>>> morning and noticed that my name wasn't on it -- I'd better get >>>>>> back >>>>>> to work. ;) >>>>>> >>>>>> -Dan >>>>>> ------------------------------------------------------------ >>>>>> http://www.StrongGraphicDesign.com >>>>>> (208) 319-0137 | Toll-free p/f 877-561-1656 >>>>>> ------------------------------------------------------------ >>>>>> >>>>>> >>>>>> >>>>>> On Thu, 6 Feb 2003 15:59:10 >>>>>> Brian B. Burton wrote: >>>>>>> Actually, I think you'd be wrong :( >>>>>>> >>>>>>> I have written part of a book, but the response to date has been >>>>>>> underwhelming. I guess it's kind of like being a shareware >>>>>>> author, >>>>>>> everybody uses shareware. 2-5% of people pay for shareware. >>>>>>> >>>>>>> The time investment in writing in a clear and concise manner, >>>>>>> along >>>>>>> with the experience needed to write such a guide makes to limited >>>>>>> to a few people in this group. I'm not saying that to be >>>>>>> arrogant, >>>>>>> but it is an accurate and true statement. On top of that, you >>>>>>> have >>>>>>> to figure out how many copies you can sell to recoup your >>>>>>> investment of time. I estimate I could sell less then 100 copies. >>>>>>> Some people think they know everything, some people wouldn't >>>>>>> spend >>>>>>> the money (I estimate it would have to be about $99 for a PDF to >>>>>>> even get close to break even vs. selling the same time being a >>>>>>> programmer), and some people will share, thus depriving yours >>>>>>> truly >>>>>>> of funds needed to eat lunch, and I've already done the starving >>>>>>> artist part of my life... >>>>>>> >>>>>>> But for all of that pessimism, I am still plodding along on my >>>>>>> book, adding and incrementing it. I'm up to about twice the >>>>>>> content >>>>>>> and am just beginning the e-commerce functionality info now. I >>>>>>> just >>>>>>> don't have the new content online anywhere at this time. >>>>>>> >>>>>>> >>>>>>> If you'd like to see what is public, please visit: http:// >>>>>>> webdna.burtons.com >>>>>>> >>>>>>> >>>>>>> Brian B. Burton >>>>>>> Burton Logistics >>>>>>> 973-263-3036 973-296-6862 (cell) >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Thursday, February 6, 2003, at 01:28 PM, Dan Strong wrote: >>>>>>> >>>>>>>> Agreed. a 'WebDNA for Dummies' book, might make somebody rich... >>>>>>>> Otherwise, Marc, yes, this list and it's archive are excellent >>>>>>>> resources. >>>>>>>> >>>>>>>> >>>>>>>> On Thu, 6 Feb 2003 10:06:25 -0800 >>>>>>>> Sales wrote: >>>>>>>>> Are there any books out there for learning WebDNA? I'm sorry, >>>>>>>>> but I've found the documentation sorely lacking for beginners, >>>>>>>>> especially with the new XML styled syntax. I did a search on >>>>>>>>> Amazon, but found nothing. >>>>>>>>> >>>>>>>>> If there aren't any books available, how have others learned >>>>>>>>> this >>>>>>>>> language? Trial and error? The documentation? This list? >>>>>>>>> >>>>>>>>> I realize this list is an excellent resource, but it would be >>>>>>>>> nice to have a good tutorial in hand. >>>> >>>> ------------------------------------------------------------- >>>> 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/ >> >> ------------------------------------------------------------ >> http://www.StrongGraphicDesign.com >> (208) 319-0137 | Toll-free p/f 877-561-1656 >> ------------------------------------------------------------ >> >> ------------------------------------------------------------- >> 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/ > ------------------------------------------------------------- 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/ Charles Kline

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:

Interesting speed comparison .. (2003) Another Large Database Questions (1997) Question about the database (was Message Boards) (2003) For those of you not on the WebCatalog Beta... (1997) Extended [ConvertChars] (1997) turning every 5th line red (1999) Emailer compatibility..... (1998) Re:Formulas.db / Quantity Discount problem (1998) sort links (2002) Is this possible in simple search? question? (1998) Re(2): Share Bulletin Board? (1998) More on the email templates (1997) Nested tags count question (1997) WCS Newbie question (1997) WCf2 and nested tags (1997) Bug? (1997) Reversing [ipaddress] normalization (1998) Virtual hosting and webcatNT (1997) Web Catalog Book? (1998) problems with 2 tags (1997)