[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/0000 or I 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:

    
  1. Re: [WebDNA] last month's last day expressed as days since 00/00/0000 would be what? (in code) (Brian Fries 2008)
  2. [WebDNA] last month's last day expressed as days since 00/00/0000 would be what? (in code) (Govinda 2008)
  3. [WebDNA] last month's last day expressed as days since 00/00/0000 would be what? (in code) (Govinda 2008)
How do I get the last day of last month? I could do the math on the number of days since 00/00/0000 or I 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)