Re: Search on Dates
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34837
interpreted = N
texte = At 6:58 PM 7/18/00, frank@usinter.net wrote:>I give up.>>Would someone give me an idea how, after I have pulled a date out of >a database (i.e.:>05/01/2000), I can then re-format it as a month only (05, or May)?>>Or maybe how just to pull May's records out of the database. >Anything I try with [date>%m] etc or [format] gives me today's date, not the database field.Hint: What is the name of the field that contains the date in the database? Clue: I hope it's not date.It's best in these cases to post your code.___Joe____________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
At 6:58 PM 7/18/00, frank@usinter.net wrote:>I give up.>>Would someone give me an idea how, after I have pulled a date out of >a database (i.e.:>05/01/2000), I can then re-format it as a month only (05, or May)?>>Or maybe how just to pull May's records out of the database. >Anything I try with [date>%m] etc or [format] gives me today's date, not the database field.Hint: What is the name of the field that contains the date in the database? Clue: I hope it's not date.It's best in these cases to post your code.___Joe____________________________________________________Joseph D'Andrea JoeDan@West21.comWEST21.com Internet services for the 21st Century http://www.west21.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://search.smithmicro.com/
Joseph D'Andrea
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:
Summing fields (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
[WebDNA] Question for WSC ... (2008)
WebCat B13 Mac CGI -- Frames question (1997)
[WebDNA] WebDNA slow processing (2011)
Error: the 'showcart' command requires that you specify a db (1997)
WebCat2b15MacPlugin - showing [math] (1997)
WebDNA hosting? ... (2004)
Errata: WCS Newbie question (1997)
[DOS]/DOS query perhaps OT (2003)
Expert tech support -- a fast and simple solution (long) ... (2000)
multiple databases (1997)
Template Encrypt Speed (1998)
creating a ShipCosts database (1997)
[WebDNA] CICADA (2009)
Protecting webdelivery (1997)
How to append text after the sign & (1997)
[WebDNA] Best practice re: password storage (2013)
Newbie Tax Question (1997)
[WriteFile] problems (1997)