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:

    
  1. 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:

WebCat2b15MacPlugin - showing [math] (1997) [SearchString] problem with [search] context (1997) Date and Time Analyzer (2000) Thread (1999) RE: protect tag on NT (1997) Alternating colors (1997) & not allowed in db by definition? (1999) Pithy questions on webcommerce & siteedit (1997) Instructions for Digest (1997) Extended [ConvertChars] (1997) Requiring that certain fields be completed (1997) Size limit for tmpl editor ? (1997) Referrer from multiple entry points (1998) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) Can ShowNext do this? (2000) Setting up WebCatalog with Retail Pro data (1996) WebDNA 6.0 NOT Configured fot accept domain (2006) Cookies and webcat (1997) SMSI: databases corrupted on crash and permission issuesonOSX (2002) Windows 2.1b2 Append Bug? (1997)