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

A Global Variable (1997) [convertChars] and HTML Tags (1997) Nesting Search Within Tag? (1997) WebCat and PDF (2000) Anyone using WebCat UNIX on a busy server yet? (1999) Calendar (1997) Replace context problem ... (1997) form population (1998) Images do not upload completely ... (2003) PIXO support (1997) Searchable WebCat (etc.) Docs ? (1997) multiple search commands (1997) ODBC and WebCatalog on Solaris and talking to a Sybase database (2001) Help! WebCat2 bug (1997) WebCatalog 2.0 b 15 mac (1997) Rollovers (1999) AuthorizeNet Declines (2005) website pro trouble (1998) Upgrading old WebCat Database Files (1997) Summing fields (1997)