Hi Sammael,

Your 'dd:hh:mm:ss' data aren't a standard format format - you need to either dispense with the 'dd:' part or add the 'mm' & 'yyyy' parts, formatted like 'dd/mm/yyyy hh:mm:ss', for example.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]