Re: Date Question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46361
interpreted = N
texte = Jeff put your [duedate] right above the showif in the founditems loop.Post exactly one of the results to the list.Donovan >>>>| [text show=f&secure=f]sort1=duedate[/text] >>>>| [text show=f&secure=f]sort2=priority[/text] >>>>| [text show=f&secure=f]showonly=all[/text] >>>>| >>>>| >>>>| [search >>>>| db=database.db&geskudata=0&as[sort1]sort=1&as[sort2]sort=2&asstatussor >>>>| t=3[hideif >>>>| [url][showonly][/url]=all]&eqprojecttypedatarq=[url][showonly][/url][/ >>>>| hideif]&duedatetype=date&prioritytype=num] >>>>| [founditems] >>>>| >>>>| [showif [duedate]<[date]]PAST DUE -> >>>>| [/showif] >>>>| >>>>| >>>>| [/founditems] >>>>| [/search]Jeff Logan wrote:> Sorry this did not work either. See my next post. > > Jeff > > >[SHOWIF [MATH]{[duedate]}<{[date]}[/MATH]=1] > > PAST DUE > >[/SHOWIF] > > > >-----Original Message----- > >From: Jeff Logan [mailto:jefftalk@insideout.com] > >Sent: Tuesday, December 17, 2002 10:09 AM > >To: WebDNA-Talk@talk.smithmicro.com > >Subject: Re: Date Question > > > >Tried it and it did not work. Any other ideas. Need me to post the full > >code? > > > >Jeff > > >>> > >>> > >>>> > >>>>| Here is the full code with a search and just what I am having a > >>>>| problem with. [duedate] is a variable in the database that compares > >>>>| against todays date to show if a project is past due or not. > >>>>| > >>>>| Jeff Logan > >>>>| > >>>>| ---- > >>>>| > >>>>| [text show=f&secure=f]sort1=duedate[/text] > >>>>| [text show=f&secure=f]sort2=priority[/text] > >>>>| [text show=f&secure=f]showonly=all[/text] > >>>>| > >>>>| > >>>>| [search > >>>>| db=database.db&geskudata=0&as[sort1]sort=1&as[sort2]sort=2&asstatussor > >>>>| t=3[hideif > >>>>| [url][showonly][/url]=all]&eqprojecttypedatarq=[url][showonly][/url][/ > >>>>| hideif]&duedatetype=date&prioritytype=num] > >>>>| [founditems] > >>>>| > >>>>| [showif [duedate]<[date]]PAST DUE -> > >>>>| [/showif] > >>>>| > >>>>| > >>>>| [/founditems] > >>>>| [/search] > >>>>| > >>>>| > >>>>| > >>>>| > >>>>| >Jeff Logan wrote: > >>>>| >> I have my search string current it is just in the show if part. > >>>>| >> > >>>>| >> [showif [duedate]<[date]] PAST DUE -> [/showif] > >>>>| >> The show if say's yes to this if the date is in 2003. > >>>>| >> > >>>>| > > >>>>| >Well, you could try this instead: > >>>>| > > >>>>| >[showif {[duedate]}<{[date]}] PAST DUE -> [/showif] > >>>>| > > >>>>| >which will compare as numbers. You aren't inside an orderfile > >>>>| >contaxt are you (since in that case [date] is the Order date not the > >>>>| >Current date)? > >>>>| > > >>>>| >John > >>>>| > > ------------------------------------------------------------------------ > ------------------------------------------------------------- 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: [WebDNA] Quick Date Question (Govinda 2008)
  2. Re: [WebDNA] Quick Date Question (Govinda 2008)
  3. Re: [WebDNA] Quick Date Question (Steve Craig 2008)
  4. Re: [WebDNA] Quick Date Question (Gil Poulsen 2008)
  5. [WebDNA] Quick Date Question (Steve Craig 2008)
  6. Re: Silly date question ( Donovan Brooke 2006)
  7. Re: Silly date question ( Donovan Brooke 2006)
  8. Re: Silly date question ( Steve Craig 2006)
  9. Re: Silly date question ( Steve Craig 2006)
  10. Re: Silly date question ( Donovan Brooke 2006)
  11. Re: Silly date question ( Gary Krockover 2006)
  12. Re: Silly date question ( Donovan Brooke 2006)
  13. Silly date question ( Steve Craig 2006)
  14. Re: Date question ( Donovan Brooke 2003)
  15. Re: Date question ( John Peacock 2003)
  16. Re: Date question ( Donovan Brooke 2003)
  17. Re: Date question ( Donovan Brooke 2003)
  18. Re: Date question ( Alex McCombie 2003)
  19. Re: Date question ( andy mowrey 2003)
  20. Re: Date question ( John Hill 2003)
  21. Date question ( andy mowrey 2003)
  22. Re: Date Question (Dan Strong 2002)
  23. Re: Date Question (Gary Krockover 2002)
  24. Re: Date Question (Dan Strong 2002)
  25. Re: Date Question (Kenneth Grome 2002)
  26. Re: Date Question (Jeff Logan 2002)
  27. Re: Date Question (Donovan 2002)
  28. Re: Date Question (Donovan 2002)
  29. Re: Date Question (Jeff Logan 2002)
  30. Re: Date Question (Chris List Recipient 2002)
  31. Re: Date Question (Jeff Logan 2002)
  32. Re: Date Question (Dan Strong 2002)
  33. Re: Date Question (Jeff Logan 2002)
  34. Re: Date Question (Gary Krockover 2002)
  35. Re: Date Question (Jeff Logan 2002)
  36. Re: Date Question (John Peacock 2002)
  37. Re: Date Question (Dan Strong 2002)
  38. Re: Date Question (Jeff Logan 2002)
  39. Re: Date Question (Dan Strong 2002)
  40. Date Question (Jeff Logan 2002)
Jeff put your [duedate] right above the showif in the founditems loop.Post exactly one of the results to the list.Donovan >>>>| [text show=f&secure=f]sort1=duedate[/text] >>>>| [text show=f&secure=f]sort2=priority[/text] >>>>| [text show=f&secure=f]showonly=all[/text] >>>>| >>>>| >>>>| [search >>>>| db=database.db&geskudata=0&as[sort1]sort=1&as[sort2]sort=2&asstatussor >>>>| t=3[hideif >>>>| [url][showonly][/url]=all]&eqprojecttypedatarq=[url][showonly][/url][/ >>>>| hideif]&duedatetype=date&prioritytype=num] >>>>| [founditems] >>>>| >>>>| [showif [duedate]<[date]]PAST DUE -> >>>>| [/showif] >>>>| >>>>| >>>>| [/founditems] >>>>| [/search]Jeff Logan wrote:> Sorry this did not work either. See my next post. > > Jeff > > >[SHOWIF [math]{[duedate]}<{[date]}[/MATH]=1] > > PAST DUE > >[/SHOWIF] > > > >-----Original Message----- > >From: Jeff Logan [mailto:jefftalk@insideout.com] > >Sent: Tuesday, December 17, 2002 10:09 AM > >To: WebDNA-Talk@talk.smithmicro.com > >Subject: Re: Date Question > > > >Tried it and it did not work. Any other ideas. Need me to post the full > >code? > > > >Jeff > > >>> > >>> > >>>> > >>>>| Here is the full code with a search and just what I am having a > >>>>| problem with. [duedate] is a variable in the database that compares > >>>>| against todays date to show if a project is past due or not. > >>>>| > >>>>| Jeff Logan > >>>>| > >>>>| ---- > >>>>| > >>>>| [text show=f&secure=f]sort1=duedate[/text] > >>>>| [text show=f&secure=f]sort2=priority[/text] > >>>>| [text show=f&secure=f]showonly=all[/text] > >>>>| > >>>>| > >>>>| [search > >>>>| db=database.db&geskudata=0&as[sort1]sort=1&as[sort2]sort=2&asstatussor > >>>>| t=3[hideif > >>>>| [url][showonly][/url]=all]&eqprojecttypedatarq=[url][showonly][/url][/ > >>>>| hideif]&duedatetype=date&prioritytype=num] > >>>>| [founditems] > >>>>| > >>>>| [showif [duedate]<[date]]PAST DUE -> > >>>>| [/showif] > >>>>| > >>>>| > >>>>| [/founditems] > >>>>| [/search] > >>>>| > >>>>| > >>>>| > >>>>| > >>>>| >Jeff Logan wrote: > >>>>| >> I have my search string current it is just in the show if part. > >>>>| >> > >>>>| >> [showif [duedate]<[date]] PAST DUE -> [/showif] > >>>>| >> The show if say's yes to this if the date is in 2003. > >>>>| >> > >>>>| > > >>>>| >Well, you could try this instead: > >>>>| > > >>>>| >[showif {[duedate]}<{[date]}] PAST DUE -> [/showif] > >>>>| > > >>>>| >which will compare as numbers. You aren't inside an orderfile > >>>>| >contaxt are you (since in that case [date] is the Order date not the > >>>>| >Current date)? > >>>>| > > >>>>| >John > >>>>| > > ------------------------------------------------------------------------ > ------------------------------------------------------------- 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/ Donovan

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:

RE: Can't get appendfile to work (1997) [WebDNA] Version 7.x: webdna.ini and EmailerPrefs (2012) Looking For WebCatalog Migration Assistance (2003) SSL and WebCatalog (1997) [carts] and databases (1997) Configuring E-mail (1997) RE: Credit Card Checksum (1997) Why does WebCat do this? (2001) WebDNA 5 - Privacy Issue (Built in sniffer) (2003) Help! WebCat2 bug (1997) Is there a max number of fields? (1998) Auto SKU's (2000) Incrementing a number (1998) RAM variables (1997) Help!!!! (1997) OT: JavaScript question (2001) refreshing IE with posted .tmpl (1997) [WebDNA] Difference in time calculations (2017) Re:Cookies and WebCat?? (1999) Any way to retrieve information from clipboard? (1998)