Date conversion
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41682
interpreted = N
texte = 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:
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/
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:
Weird error/limit - something amiss? (1997)
Only charge card when product shipped ? (1997)
Practical Uses (2003)
Protect (1997)
What is this error message? (2006)
assigning a id no. (2000)
Problems appending to database (1997)
off topic fetch vs PCS photomaster (1997)
What if SSL server down? MAC (1997)
Server crash (1997)
process SSI (1998)
WC2f3 (1997)
Newbie questions (1999)
Summing fields (1997)
Showif Error Generated... (2003)
WCS Newbie question (1997)
Template Encrypt Speed (1998)
The max=0 issue is a bug ... CALL TO ACTION (2000)
Weird Math and SV (1997)
Adding freight and percentages (2000)