Beverly,
You can convert a number to a string using the FormatNumber function. You could do something like FormatNumber(Week(date), “#”). This would return the week in a string format. To get the single digit year you could convert the year to a sting using the same function and then use the SubStr function to extact the last number.
Kerry
If I could convert the “50” (week result) to a string, then I could concatonate that string with a single digit year which I derive from using TO_CHAR in Design on the Purchase date–creating another object called Purchase Date to String and use the substr function to grab the single digit year. I can also grab the year like I just described and convert it back to a number. My PROBLEM: I don’t see how to make the WEEK of the Purchase Date into a string. And I don’t see how to perform contatonation without both items being strings.
Listserv Archives (BOB member since 2002-06-25)