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.