Re: HELP WITH DATES
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10457
interpreted = N
texte = >Will it be able to deal with my preferred YEAR/MONTH/DAY format (as in >1997/04/23) instead of just understanding MONTH/DAY/YEAR?It looks at the preferences for date format (which until now has only referred to your preference for OUTPUT) and deduces from that what the date input format should be.>How is it going to detect whether or not there's a date in the math >context? In other words, what's it looking for that makes it decide that >it's dealing with a date instead of a text string? Just the slashes? Or two >slashes separated by two other characters? or ???It looks for sequences of numbers like xx/xx/xx and assumes that is a date. So you _cannot_ create a math context that has 2 divisions in a row. If you use parentheses you could create the 2 divisions.I am leaning toward a WebDNA assumption that if there's a date in the math context anywhere, then it is assumed that the results of the math context will look like a date instead of a number.[math]12/3[/math] yields 4 [math]12/3/96+1[/math] yields 12/4/96 [math]12/3/96+0/0/1[/math] yields 12/3/97The whole idea here is to make the syntax for date manipulation a lot easier. Currently you can do it, but it takes a lot of [ConvertDate] stuff, and all numbers are in seconds. So the second line above reads (in b12 WebDNA):[format date][math][convertdate]12/3/96[/convertdate]+86400[/math][/format]Which is the same thing, except it forces you to know there are 86400 seconds in a day.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com ------------------------------------ To leave this talk list send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Associated Messages, from the most recent to the oldest:
>Will it be able to deal with my preferred YEAR/MONTH/DAY format (as in >1997/04/23) instead of just understanding MONTH/DAY/YEAR?It looks at the preferences for date format (which until now has only referred to your preference for OUTPUT) and deduces from that what the date input format should be.>How is it going to detect whether or not there's a date in the math >context? In other words, what's it looking for that makes it decide that >it's dealing with a date instead of a text string? Just the slashes? Or two >slashes separated by two other characters? or ???It looks for sequences of numbers like xx/xx/xx and assumes that is a date. So you _cannot_ create a math context that has 2 divisions in a row. If you use parentheses you could create the 2 divisions.I am leaning toward a WebDNA assumption that if there's a date in the math context anywhere, then it is assumed that the results of the math context will look like a date instead of a number.
[math]12/3[/math] yields 4
[math]12/3/96+1[/math] yields 12/4/96
[math]12/3/96+0/0/1[/math] yields 12/3/97The whole idea here is to make the syntax for date manipulation a lot easier. Currently you can do it, but it takes a lot of [ConvertDate] stuff, and all numbers are in seconds. So the second line above reads (in b12 WebDNA):[format date]
[math][convertdate]12/3/96[/convertdate]+86400[/math][/format]Which is the same thing, except it forces you to know there are 86400 seconds in a day.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com ------------------------------------ To leave this
Talk List send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Grant Hulbert
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:
SQLCONNECT (2005)
[countWords]? (1997)
I get a lot of spam (2002)
NumFound (1999)
showif funnyness in Netscape only. (2002)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] Processor Maxing out (2010)
about this server and links to who (1997)
Feature req. (2002)
RE: Can a database get stomped by simultaneous access? (1997)
[WebDNA] Commas within table content (2009)
Memory leak with text variables (1998)
another problem (1997)
[WebDNA] WebDNA 7 (2011)
WebCat2 Append problem (B14Macacgi) (1997)
Preloading code? (2002)
Multiple catalog databases and showcart (1997)
WebCatalog Help (2002)
Frames and cart values (1998)
2.1 bugs left over from beta cycle (1998)