Thanks Anil. That works for GetDate() but what happens if you apply the
formula to a field in which the date is only present some of the time/
When the date is not present the value output into the field is 0/0/. Is
there anyway to overcome this. I have tried various functions and
nothing gets parsed.