I need to convert text date to date for sorting 2

[Jinny]

I have a text log that shows the date and time as:
[19/Mar/2001:08:00:06 -0600]

Now I need a formula to convert the date so it can be sorted.

 

[kenhamady]

Try:

DateTimeValue (CDate ({field}[1 to 11]), CTime({field}[13 to 20])) Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/