var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors