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:
Template Cache problem (2000)
WebCatalog f2 Installation (1997)
Writefile outside WebSTAR hierarchy? (1997)
[search] in formulas.db (1997)
international time (1997)
[shell] (2002)
Regular expression to match email address (2003)
Grouping search fields, etc. (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
Table code broken? (2004)
SSL (1998)
Re:quit command on NT (1997)
cookies and [returnraw] (1997)
WebCat2: Formulas.db question (1997)
AppleScript/.db (was:FTP to WebStar) (2001)
WebDNA 4.5 upgrade? (2002)
Using Currencies other than Dollars (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
b12 cannot limit records returned and more. (1997)
WebCatalog 4 Install Problems - Not Answered ?? (2000)