Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: CelticKaren
- Order by date
-
Military time to Standard time
You put me on the right trail. Turns out I needed to check for blank, in addition to null. Thank you for your help.- CelticKaren
- Post #8
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Military time to Standard time
Actually, {TC1_TimecardMastefile.TimePunchedOut} is a string-type field. And when I take out the ToNumber function, Crystal responds "a number is required here". The values in the field are, for example, 10.62 and 11.98. So, I really don't understand why I'm getting "the string is non-numeric"...- CelticKaren
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Military time to Standard time
Crystal 10. I need to convert a string-type field that contains mililary time to standard time. I tried the above formula, but get the message "the string is non-numeric" and it highlights: ToNumber ({TC1_TimecardMastefile.TimePunchedOut}); Can anyone tell me what is the problem?- CelticKaren
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
