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.com WEST21.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:

    
  1. Re: Search on Dates (frank@usinter.net 2000)
  2. Re: Search on Dates (Joseph D'Andrea 2000)
  3. Re: Search on Dates (Anup Setty 2000)
  4. Search on Dates (frank@usinter.net 2000)
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.com WEST21.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)