converting general text to date time

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "meyerelie@xxxxxxxxx" <meyerelie@xxxxxxxxx>
Date: 21 May 2006 11:52:52 -0700

im trying to extract time date from:

05:20:2006:18:45:50

i could use the mod function but the data is not in date time format.

How to i convert the above into date time format so that i can extract
the time data from it?

thanks

.

Follow-Ups:
- Re: converting general text to date time
  - From: Ragdyer
- Re: converting general text to date time
  - From: Peo Sjoblom

Prev by Date: Too many functions?
Next by Date: Re: converting general text to date time
Previous by thread: Too many functions?
Next by thread: Re: converting general text to date time
Index(es):
- Date
- Thread