It looks like you are trying to calculate the first and last day of a moth in a given year. Take a look at the attached (commented) TML file for this algorithm, and let me know if this helps.
As for the ranges: You already know that there are 12 months in a year, you can loop through the year(s), and inside the years loop, you can then loop through the month(s) calculating the start/end days of each of the months. You can assign the dates you've calculated into to an array. You can use ADDROWS if you don't know how big the array will be before you start. Anthony - [EMAIL PROTECTED] ----- Original Message ----- From: "John Hollister" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Sunday, November 03, 2002 12:48 Subject: Witango-Talk: date script > I need to get the start end date for each date within a set of dates > > From 8/01/2001 to 2/01/2002 > And I need to get this in a new array > > 8/01/2001, 8/31/2001; > > 9/01/2001, 9/30/2001; > > 10/01/2001, 10/31/2001; > > 11/01/2001, 11/30/2001; > > 12/01/2001, 12/31/2001; > > 01/01/2001, 01/31/2001; > > 02/01/2001, 02/28/2001; > > or a scripts that would help me maybe pre sort the month/Year in a > stored query? > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body
date.zip
Description: Zip compressed data
