Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: Convert Text String to Time Value

    I'm looking for a formula/variable to convert time data stored as a text string to a time value because it displays as military time. When I use the time functions in Crystal I receive "Bad Time Format" everytime the report is run.

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85
    Have you tried the CDateTime() function?

    I've never needed it, but v8.5 says it will covert a string or a number into a Date/Time field.

    You may have to rearrange the text so that day,month and year are in the right order and do some mathematical gymnastics to convert from a 24-hour clock to a 12 hour clock.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •