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:
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:
Robots fill event log (1997)
[format 40s]text[/format] doesn't work (1997)
multiple search of same field (1999)
Date search - yes or no (1997)
OT: JavaScript question (2001)
Associative lookup style? + bit more (1997)
unsubscribe (1997)
What's New Date (2002)
WebCat2b12 - nesting [tags] (1997)
Running 2 two WebCatalog.acgi's (1996)
Navigator 4.01 (1997)
Database field limit? (1998)
[WebDNA] Server 2012 R2 (2014)
2.0 Info (1997)
Displaying xx number of characters (1997)
POP Mail Server Reseting (1998)
wrong authentication (1998)
Serving images from databases (1998)
Help name our technology! (1997)
Re:2nd WebCatalog2 Feature Request (1996)