Re: Date conversion
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41715
interpreted = N
texte = Thanks Brian.> From: Brian Fries
> Reply-To: (WebCatalog Talk)> Date: Wed, 17 Jul 2002 15:39:38> To: (WebCatalog Talk)> Subject: Re: Date conversion> > You need to make the values you're searching for match the format of> the values in the database. Also, set the type to NUM instead of DATE.> > Try:> > &rnEventDatedatarq=[format days_to_date %Y%m%d][from_date][/format]> [format days_to_date %Y%m%d][to_date][/format]&eventDatetype=num> > - brian> > At 2:52 PM -0800 7/17/02, Ken MacMurchy wrote:>> Hi group, I have an imported db that has a field [Event Date] and it is in>> the format yyyymmdd.>> >> I know I can use:>> >> [text]yyyy=[getchars start=1&end=4][Event Date][/getchars][/text]>> [text]mm=[getchars start=5&end=6][Event Date][/getchars][/text]>> [text]dd=[getchars start=7&end=8][Event Date][/getchars][/text]>> [text]convDate=[mm]/[dd]/[yyyy][/text]>> >> to get my mm/dd/yyyy format, but I'm trying to use date comparisons from>> drop downs on the previous page.>> Using:>> [math date]from_date={[Smonth]/[Sday]/[Syear]}[/math]>> [math date]to_date={[Emonth]/[Eday]/[Eyear]}[/math]>> >> My search is as follows, but I'm not sure how to get it to work with the>> search. Please help.>> >> [search>> db=eparchive.db&[search_string]=search_string&eqcreatedrq=[created]&rnEvent>> Datedatarq=[formatdays_to_date][from_date][/format] [format>> days_to_date][to_date][/format]&Event Datetype=date]]>> >> TIA>> ======================================>> Cheers!>> >> Ken MacMurchy>> web developer>> email: ken.macmurchy@leaderpost.com>> web: http://www.leaderpost.com>> 306-565-8299>> 1964 Park St.>> Regina, SK, Canada>> S4P 3G4> > -------------------------------------------------------------> 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/> > ------ End of Forwarded Message> -------------------------------------------------------------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:
Thanks Brian.> From: Brian Fries > Reply-To: (WebCatalog Talk)> Date: Wed, 17 Jul 2002 15:39:38> To: (WebCatalog Talk)> Subject: Re: Date conversion> > You need to make the values you're searching for match the format of> the values in the database. Also, set the type to NUM instead of DATE.> > Try:> > &rnEventDatedatarq=[format days_to_date %Y%m%d][from_date][/format]> [format days_to_date %Y%m%d][to_date][/format]&eventDatetype=num> > - brian> > At 2:52 PM -0800 7/17/02, Ken MacMurchy wrote:>> Hi group, I have an imported db that has a field [Event Date] and it is in>> the format yyyymmdd.>> >> I know I can use:>> >> [text]yyyy=[getchars start=1&end=4][Event Date][/getchars][/text]>> [text]mm=[getchars start=5&end=6][Event Date][/getchars][/text]>> [text]dd=[getchars start=7&end=8][Event Date][/getchars][/text]>> [text]convDate=[mm]/[dd]/[yyyy][/text]>> >> to get my mm/dd/yyyy format, but I'm trying to use date comparisons from>> drop downs on the previous page.>> Using:>> [math date]from_date={[Smonth]/[Sday]/[Syear]}[/math]>> [math date]to_date={[Emonth]/[Eday]/[Eyear]}[/math]>> >> My search is as follows, but I'm not sure how to get it to work with the>> search. Please help.>> >> [search>> db=eparchive.db&[search_string]=search_string&eqcreatedrq=[created]&rnEvent>> Datedatarq=[formatdays_to_date][from_date][/format] [format>> days_to_date][to_date][/format]&Event Datetype=date]]>> >> TIA>> ======================================>> Cheers!>> >> Ken MacMurchy>> web developer>> email: ken.macmurchy@leaderpost.com>> web: http://www.leaderpost.com>> 306-565-8299>> 1964 Park St.>> Regina, SK, Canada>> S4P 3G4> > -------------------------------------------------------------> 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/> > ------ End of Forwarded Message> -------------------------------------------------------------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/
Ken MacMurchy
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:
[WebDNA] Flippage & SWCTools (2010)
no [search] with NT (1997)
[math] show=F exists? (1997)
BBEdit WedDNA Codeless Language Module (2004)
WebDNA Solutions ... sorry! (1997)
refreshing IE with posted .tmpl (1997)
[append] vs. [appendfile] delta + question? (1997)
javascript problem copying values (2000)
Help! WebCat2 bug (1997)
SendMail - Idea (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Unexpected error (1997)
redirect with frames (1997)
[WebDNA] MD5 encryption (2011)
Country & Ship-to address & other fields ? (1997)
Trouble with formula.db (1997)
Need help... (1997)
Feature: TCPconnect via SSL (1999)
Allow-Deny: Solved with [Getchars] (1998)
email program problem (1998)