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:
Cookies not setting on IE (2002)
WebDNA and PostGres SQL (2005)
Site Test Please (2005)
Stop the madness. (1997)
2.0 Info (1997)
Price override (2004)
[sendmail] from a post (2007)
Summing results of a nested search (2006)
Bug Report, maybe (1997)
WebCatalog/WebMerchant bug? (1999)
Problems with date math (1997)
What week is first? (1998)
Nested search (1997)
WC2b15 File Corruption (1997)
TCPConnect / TCPSend to Solaris NN Enterprise (2002)
Secure Server (1999)
[Listfiles] vs Netfinder (1997)
emailer w/F2 (1997)
problems with 2 tags shakur (1997)
Web Catalog vs. ICAT (1997)