[WebDNA] last month's last day expressed as days since 00/00/0000 would be what? (in code)
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101064
interpreted = N
texte = How do I get the last day of last month?I could do the math on the number of days since 00/00/0000orI could do the math on the {dates}but in both cases I would have to do a lot of conditionals:[if ("[thisMonth]"="[april]") | ("[thisMonth]"="[jun]") | ("[thisMonth]"="[aug]") | ,etc....][then][text]ThisMonthsLastDigit=30[/text][/then][else][text]ThisMonthsLastDigit=31[/text][/else][/if][showif [URL][thisMonth][/URL]=feb][text]ThisMonthsLastDigit=28[/text][/showif][if ("[thisYearTYPE]"="[leapyear]") & ("[thisMonth]"="[feb]")][then][text]ThisMonthsLastDigit=29[/text][/then][/if]and there are deeper cycles, I understand, like every 10th year we skip a leap year, (or something like that), etc.SO I figure it is a waste of time to rewrite the date libraries WebDNA uses. So back to my question:Given that I don't know what month it is now, what WebDNA logic/code do I need to use to figure out whether last month's last day's digit is "28", "29", "30", or "31"?...and if this is any easier, what I am ultimately after is the exact number (a date "expressed as days since 00/00/0000") of the *first* day of last month, and the *last* day of last month.Thanks for any help!-Govinda
Associated Messages, from the most recent to the oldest:
How do I get the last day of last month?I could do the math on the number of days since 00/00/0000orI could do the math on the {dates}but in both cases I would have to do a lot of conditionals:[if ("[thisMonth]"="[april]") | ("[thisMonth]"="[jun]") | ("[thisMonth]"="[aug]") | ,etc....][then]
[text]ThisMonthsLastDigit=30[/text][/then][else]
[text]ThisMonthsLastDigit=31[/text][/else][/if][showif
[url][thisMonth][/URL]=feb]
[text]ThisMonthsLastDigit=28[/text][/showif][if ("[thisYearTYPE]"="[leapyear]") & ("[thisMonth]"="[feb]")][then]
[text]ThisMonthsLastDigit=29[/text][/then][/if]and there are deeper cycles, I understand, like every 10th year we skip a leap year, (or something like that), etc.SO I figure it is a waste of time to rewrite the date libraries WebDNA uses. So back to my question:Given that I don't know what month it is now, what WebDNA logic/code do I need to use to figure out whether last month's last day's digit is "28", "29", "30", or "31"?...and if this is any easier, what I am ultimately after is the exact number (a date "expressed as days since 00/00/0000") of the *first* day of last month, and the *last* day of last month.Thanks for any help!-Govinda
Govinda
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:
woops - speed results - right subject (2002)
NT Version on IIS 4.0 (1997)
Math Context (1998)
WebCat2b15MacPlugin - [protect] (1997)
E-mail loop ! (1997)
Remove a Field from a DB (2007)
WebDNA 5.0 Questions (2003)
webdna dreamweaver extension (2003)
The Guru Speaks-Is That Really the Only Manuel? (1998)
Trouble with formula.db (1997)
Error Lob.db records error message not name (1997)
WebCat2 - Getting to the browser's username/password data (1997)
emailer (1997)
Progress !! WAS: Trouble with formula.db (1997)
WebCat2 Append problem (B14Macacgi) (1997)
upgrading (1997)
searchable list archive (1997)
How to set triggers (1998)
Authenticate (1997)
Dreamweaver Extensions for WC (2000)