don't worry about this post, i have sorted my issue.

Thats what I have been thinking. Unfortunately, the company will not give me the source code so that I can debug it (which is understandable).  The confusing thing is that...

Yes, the coversion program (here) is not converting any of the dates with the day >12  ie it is treating this field as the month and therefore anything over 12...

Seeing I could not get it to work the first time, I changed my regional settings to mm/dd/yy to see if this would make it work. All our servers are...