Searching/sorting dates

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13989
interpreted = N
texte = Does or does not WebCat work with international dates? The doc states that international dates can be used and sorting, comparision and summaries works with dates formatted as set in the general prefs, but my experiences today says different :-(Prefs is date formatted as %Y-%m-%d and that works good. we have allso formatted the dates in our .dbs in the same format. But no searches or sortings work at all, like:[Search db=9798/spelprogram.db&eqHemmalagdata=IK Pantern&geDatumdata=[DATE]&Datumtype=date&Datumsort=1&AllReqd=T]This search returns some of the entrys in the database but not all, sorted first by day number and then by month number:1997-02-01 1997-03-01 1997-04-01 1997-05-01 1997-06-01 1997-07-01 1997-08-01 1997-09-01 1997-10-01 1997-11-01 1997-12-01 1997-01-02I have work around the problem by formatting our dates like 1/1/1997, but that's not a solution in the long run - forcing our clients to use a non-native date format. ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching/sorting dates (Grant Hulbert 1997)
  2. Searching/sorting dates (Christer Olsson 1997)
Does or does not WebCat work with international dates? The doc states that international dates can be used and sorting, comparision and summaries works with dates formatted as set in the general prefs, but my experiences today says different :-(Prefs is date formatted as %Y-%m-%d and that works good. we have allso formatted the dates in our .dbs in the same format. But no searches or sortings work at all, like:[Search db=9798/spelprogram.db&eqHemmalagdata=IK Pantern&geDatumdata=[date]&Datumtype=date&Datumsort=1&AllReqd=T]This search returns some of the entrys in the database but not all, sorted first by day number and then by month number:1997-02-01 1997-03-01 1997-04-01 1997-05-01 1997-06-01 1997-07-01 1997-08-01 1997-09-01 1997-10-01 1997-11-01 1997-12-01 1997-01-02I have work around the problem by formatting our dates like 1/1/1997, but that's not a solution in the long run - forcing our clients to use a non-native date format. ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Art director S-211 37 Malmoe Fax +46 40 97 99 77 Ljusa Ideer AB Sweden http://www.ljusaideer.se Christer Olsson

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:

New Install (2003) WebCat2: multiple currency support (1997) Need Advice for Setting up a Database (1999) Repost paging through results detail view (2003) Re:quit command on NT (1997) [WebDNA] Show next..... (2010) OFF TOPIC - sendmail problem (2003) categories (1997) [WebDNA] Upgrade from OS 10.7.5 WebDNA 6.2 to Mavericks (2013) Error Lob.db records error message not name (1997) Multiple Pulldowns/Gary (1997) RE: New WebCatalog Version !!! (1997) Thanks SMSI (2003) Shell traceroute (2001) WebCat2.0 [format thousands .0f] no go (1997) NTbeta18 corrupted? (1997) WebCat2 - storing unformatted date data? (1997) Cart doesn't interpret tag! (1997) ConvertChars request (1999) Cart Number sequence (1997)