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:
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:
300 ticks (2003)
Calculating multiple shipping... (1997)
Removing [showif] makes a big difference in speed (1997)
WebCat2b15MacPlugin - [protect] (1997)
Multiple fields on 1 input (1997)
Add message to Order (1997)
Banners (1997)
Q: for those who use Cookies for sessions? (2004)
Add to Cart & List of Products (1997)
unsubscribe (1997)
2cd pair.. [math] and European Date format (2004)
Execute Applescript (1997)
[price] via a search (1998)
Logging purchases (1997)
RE: [WebDNA] WebDNA app (2013)
Banner DNA (1997)
HELP WITH DATES (1997)
PSC recommends what date format yr 2000??? (1997)
Moment of Thanks (1997)
WebDNA 5.x & iTools 7 & Apache 2 (2003)