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:

    
  1. Re: Date conversion (Jarveefor1@aol.com 2002)
  2. Re: Date conversion (Jarveefor1@aol.com 2002)
  3. Re: Date conversion (Ken MacMurchy 2002)
  4. Date conversion (Ken MacMurchy 2002)
  5. Re: Date conversion (Jarveefor1@aol.com 2002)
  6. Re: Date conversion (Brian Fries 2002)
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)