I can't possibly be the first person to have this issue. Maybe I'm just ignorant of an easy function to do this.
Here goes:
I want to make an alpha field to say a date range such as "01/16/2004 to 02/15/2004" but I have to calculate the months. conceptually I want to do: ((month - 1)|'/'|'16/'|year|' to '| month | '15/' | year)
this is clearly not legal since the output needs to be in alpha and I'm doing arithmatic.
is there a way to do this arithmatic and cast it to char inline? it would make sense to me to do something like
BY COUNTRY ENDThis message has been edited. Last edited by: <Mabel>,
May 10, 2004, 05:18 PM
George Brown
Thanks Pietro De Santis!
This worked with some minor differences. Rather than a compute I used a define so I could put it in the header. The code was great though... thanks again
May 11, 2004, 04:32 AM
susannah
George, since you're putting it all in a header, how about just using smart dates for the 2 dates: HEADING "TABLE FILE something do stuff BY DATE1 NOPRINT BY DATE2 NOPRINT END where the dates are formated DATE/MtDYY , which is very nice looking