I wish it was as simple as the date/time settings.

Here is my code:

if DTSSource("ProcDate") > " " then

i_Day = (Mid(DTSSource("ProcDate").Value ,7 , 2 ))

i_Month = (Mid(DTSSource("ProcDate").Value ,5 , 2 ))

i_Year...

Thanks Russel - you are a star !