[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:

[WebDNA] 2 x servers, 1 x db (2018) Problems passing [SKU] with $Replace in 2.0 (1997) Just a thought (1998) WebCommerce: Folder organization ? (1997) Replace Missing Images (2003) [Sum] function? (1997) Problems with [Applescript] (1997) Shipping charges based on dollar level (1997) bannerads example idiot (1997) Password problems with WebCat 4.01 (2000) Removing [showif] makes a big difference in speed (1997) Webcat no longer supported? (2006) PCS Frames (1997) Plugin or CGI or both (1997) ReadDateFormat bug in 3.x (1998) final on include (1997) Bugs? What Bugs? was:Spawning Holdup? (2000) WC Database Format (1997) Re:[ShowIf] and empty fields (1997) Help formatting search results w/ table (1997)