• wow thanks for the quick reply it worked, i changed the day to

    + '01' as need it to represent 01 always.

    Intrigued as to why need to *1000 for year and *100 month?

    Will this still if work if month = 10, 11 or 12?