Skip to Content
Former Member
Jul 21, 2009 at 01:48 PM

Converting Date Strings To Text


I am trying to select records based on a date string of the format "21/07/2009 07:25:55.703". This date is contained in a CSV file and I am usng ODBC to connect to the data source. My probllem is I am unable to covert this "String" to a Date Time value using Cryttal standard functions.

I have tested the record selection by manually removing the fraction of a second portion of the string and it works fine. Any suggestions on ways I can handle this string.

I am relatively new to Crystal reports so samples of some useful code would be appreciated.