My apologies for the 'gents' salutation. What was I thinking.

Thanks for the response. I just created something to mimic what I have currently. But yes I do need all...

Thanks Lowell, Paul and Steve, the solutions are brilliant. Definitely learnt a lot. YOu are all appreciated.

Thanks for all your help guys, I will be more clear moving forward.

I have been working on a way to separate the month from the year and this is...

still not getting the desired output.

i am trying to achieve this by maybe seperating both numbers into two columns, i came up with this script to display all the records on the left of the...

this is exactly what i wanted thank you very much. i made a slight mistake in the question however.

TheFinalResult column is actually month/year not month/day.

One last question would be...