Re: Date Question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46353
interpreted = N
texte = Have you tried John's suggestion with the curly brackets? [showif {[duedate]}<{[date]}] PAST DUE -> [/showif]On Tue, 17 Dec 2002 09:48:44 -0800 Jeff Logan wrote: >>Not to point out the obvious, but since the font color is white for the >>output from the showif, is your background perhaps white also? >> >>Just thought I'd throw that in there...I miss the obvious all the time, not >>saying you do. >> > >Background is gray. > >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 >>| > >>| >-- >>| >John Peacock >>| >Director of Information Research and Technology >>| >Rowman & Littlefield Publishing Group >>| >4720 Boston Way >>| >Lanham, MD 20706 >>| >301-459-3366 x.5010 >>| >fax 301-429-5747 >> >>------------------------------------------------------------- >>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/ > > >Personal service is #1 priority to us. > >------------------------------------------------ >InsideOut Marketing and Web Solutions >Web, Marketing and Print Design >Toll Free: 1-800-500-8401 >Phone: 360.683.5774 Fax: 360.683.5857 >Email: mailto:jeff@insideout.com >229 South Sequim Ave, Sequim, WA 98382 >http://www.insideout.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/ 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)
Have you tried John's suggestion with the curly brackets? [showif {[duedate]}<{[date]}] PAST DUE -> [/showif]On Tue, 17 Dec 2002 09:48:44 -0800 Jeff Logan wrote: >>Not to point out the obvious, but since the font color is white for the >>output from the showif, is your background perhaps white also? >> >>Just thought I'd throw that in there...I miss the obvious all the time, not >>saying you do. >> > >Background is gray. > >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 >>| > >>| >-- >>| >John Peacock >>| >Director of Information Research and Technology >>| >Rowman & Littlefield Publishing Group >>| >4720 Boston Way >>| >Lanham, MD 20706 >>| >301-459-3366 x.5010 >>| >fax 301-429-5747 >> >>------------------------------------------------------------- >>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/ > > >Personal service is #1 priority to us. > >------------------------------------------------ >InsideOut Marketing and Web Solutions >Web, Marketing and Print Design >Toll Free: 1-800-500-8401 >Phone: 360.683.5774 Fax: 360.683.5857 >Email: mailto:jeff@insideout.com >229 South Sequim Ave, Sequim, WA 98382 >http://www.insideout.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/ Dan Strong

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:

WCS Newbie question (1997) [include ...] behavior (1997) Execute Applescript (1997) WebCat editing, SiteGuard & SiteEdit (1997) Change Subtotal (2000) system crashes, event log (1997) Trouble with formula.db + more explanation (1997) What's up with digger? (2004) Show if time tags (1997) A little syntax help (1997) Merchant account (1998) Attn: Bug in GeneralStore example b15 (1997) PDA Browser Emulator (2006) Protect (1997) [WebDNA] writing pdfs on the fly (Avery labels #5160) (2010) Digest for 4/18/97 (1997) IIS4/WebCat3.0 Authentication (1999) Nested tags count question (1997) Forcing a NEWCART (1997) Redirect frame targets (1998)