Re: webcat2b12 CGI -- Date comparisons

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 10490
interpreted = N
texte = >(I'm forwarding this from a tech support question so we can talk about it>publicly in case there's something we can all learn from it)>--------------------------->The following will only find records where the date is equal. It doesn't>find the records where the date is greater than, which is what I expect>with 'ge':>>[Search db=shops.db&modifiedtype=date&gemodifieddata=[format date>%d/%m/%Y][math][convertdate][date>%m/%d/%Y][/convertdate]-604800[/math][/format]&namesort=1]This is why I prefer a standard date format of [%Y/%m/%d] in all the datefields in my databases.Whenever the date is formatted with the time divisions from the largest tothe smallest, WebDNA will understand 'gt' or 'ge' or 'lt' or 'le' or 'eq'within a text-only context - no need to tell it you're dealing with a date(as in '&modifiedtype=date').If the date field (in the example here, the user calls it the 'modified'field) were in this format, the following would work:[Search db=shops.db&gemodifieddata=[dateValueFromTheInputForm]&namesort=1]Sincerely,Ken------------------------------------To leave this talk list send an email to macjordomo@smithmicro.comwith BODYunsubscribe WebDNA-Talk------------------------------------  Associated Messages, from the most recent to the oldest:

Re: webcat2b12 CGI -- Date comparisons (Kenneth Grome 1997) webcat2b12 CGI -- Date comparisons (Grant Hulbert 1997)

>(I'm forwarding this from a tech support question so we can talk about it>publicly in case there's something we can all learn from it)>--------------------------->The following will only find records where the date is equal. It doesn't>find the records where the date is greater than, which is what I expect>with 'ge':>>[Search db=shops.db&modifiedtype=date&gemodifieddata=[format date>%d/%m/%Y][math][convertdate][date>%m/%d/%Y][/convertdate]-604800[/math][/format]&namesort=1]This is why I prefer a standard date format of [%Y/%m/%d] in all the datefields in my databases.Whenever the date is formatted with the time divisions from the largest tothe smallest, WebDNA will understand 'gt' or 'ge' or 'lt' or 'le' or 'eq'within a text-only context - no need to tell it you're dealing with a date(as in '&modifiedtype=date').If the date field (in the example here, the user calls it the 'modified'field) were in this format, the following would work:[Search db=shops.db&gemodifieddata=[dateValueFromTheInputForm]&namesort=1]Sincerely,Ken------------------------------------To leave this Talk List send an email to macjordomo@smithmicro.comwith BODYunsubscribe WebDNA-Talk------------------------------------  Kenneth Grome

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:

Stumpted Again (1997) 2nd WebCatalog2 Feature Request (1996) Major problem SOLVED! (1999) Unix webcat perms & multiple versions of same db in cache issue (2000) [WebDNA] [array] tag (2008) WebCommerce: Folder organization ? (1997) my price won't move (1997) Erotic Sites (1997) Searchable Archives? (2000) taxTotal problem (1998) WebCatalog Hosting (1996) WebDNA vs PHP (2003) Question on the sandbox (2003) question: webmerchant connection (1997) Re:One more time (1997) unable to launch acgi in WebCat (1997) Requiring that certain fields be completed (1997) Re:Running 2 two WebCatalog.acgi's (1996) WebCat2: Items xx to xx shown, etc. (1997) [TaxableTotal] - not working with AOL and IE (1997)