Suggestions on best way to work with yyyy/mm/dd
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12939
interpreted = N
texte = Our online store is up and running fine, but we are using dates with the format of yy/mm/dd format and wish to exploit the date range search on the databases. There are several options on how we can handle the move over to mm/dd/yy form.1) Keep our databases the way they are and write an extractor template that would extract the info we wish to search and munge the dates into the proper date format so search would work?2) Write a specialize template that would replace our dates in yy/mm/dd format with dates of mm/dd/yy format and change webcat pref to work that way. I'm just looking for suggestions of which way would be more expedient. Also, if the replace option is the way to go, I'm not sure of how that would work. Can you manipulate date fields in more than one format within the replace action line? Thanks for any help or suggestions?Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ----------------------------------------------------------------------
Associated Messages, from the most recent to the oldest:
| |
- Suggestions on best way to work with yyyy/mm/dd (w curt eggemeyer 1997)
|
Our online store is up and running fine, but we are using dates with the format of yy/mm/dd format and wish to exploit the date range search on the databases. There are several options on how we can handle the move over to mm/dd/yy form.1) Keep our databases the way they are and write an extractor template that would extract the info we wish to search and munge the dates into the proper date format so search would work?2) Write a specialize template that would replace our dates in yy/mm/dd format with dates of mm/dd/yy format and change webcat pref to work that way. I'm just looking for suggestions of which way would be more expedient. Also, if the replace option is the way to go, I'm not sure of how that would work. Can you manipulate date fields in more than one format within the replace action line? Thanks for any help or suggestions?Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ----------------------------------------------------------------------
w curt eggemeyer
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:
Smart caching problems with 2.1b3? (1997)
raw=T is broken in [include] (1997)
Writefile outside WebSTAR hierarchy? (1997)
Exclamation point (1997)
da webcat, da merchant, da auth (1998)
Some ThankYou page problems (1997)
Is Web Merchant Necessary? (2000)
Hosting Services (1999)
WebCat2 - [format thousands] (1997)
hiding return characters (2000)
Card clearance, problems - solutions? (1997)
Multiple prices (1997)
[WebDNA] hide [DOS] command strings on resulting page (2016)
Google Web Accelerator (2005)
[WebDNA] Libmysql.dll error (2009)
RE:ShowIf & HideIf Question? (1998)
Trouble with Showif and Search (1998)
[sendmail] and [formvariables] (1997)
WebCat2 Append problem (B14Macacgi) (1997)
[Correction] Why does lineitems loop in sendmail = crash ? (2000)