Re: Date Question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46346
interpreted = N
texte = 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.GK | 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/ 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)
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.GK | 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/ Gary Krockover

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:

[Cart] ... (1997) Draft Manual, Tutorial, and more (1997) Fun with Dates - finally resolved but.... (1997) Shopping cart now good (fixed it) (1997) Tea Room trouble (1997) Search Folder? (1998) Monitoring Script (2008) BACKGROUND (2000) WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997) Quitting WebMerchant ? (1997) Problems with [Applescript] (1997) Multiple fields on 1 input (1997) Hiding Email Addresses (2003) [WebDNA] Replace / Append only unique data (2013) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) eCommerce Idea Patented? (2002) Execute Applescript (1997) creator code (1997) Text limits in NT version? (1997) setitems, one more thing (1997)