Re: Date conversion

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 41680
interpreted = N
texte = 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- brianAt 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/ Associated Messages, from the most recent to the oldest:

Re: Date conversion (Jarveefor1@aol.com 2002)
Re: Date conversion (Jarveefor1@aol.com 2002)
Re: Date conversion (Ken MacMurchy 2002)
Date conversion (Ken MacMurchy 2002)
Re: Date conversion (Jarveefor1@aol.com 2002)
Re: Date conversion (Brian Fries 2002)

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- brianAt 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/ Brian Fries

DOWNLOAD WEBDNA NOW!

Re: Date conversion

2002

Top Articles:

Related Readings: