I am trying to create a report and I am having a problem with the month caculation. The data is stored a numeric field called month but the months start at number 1 for January and keep continue on through 12 for December. The next year starts with 13 for January and ends with 24 for December, and then starts with month 25 January ends with 36 December and so on.
I have created a caculation to seperate out the different years, but now I am stuck on how I will caculate the months. I figured in the end I could concatenate year and month to get the desired result.
Does anyone have any suggestions?