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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by keArts
-
How to convert a date string into a true date?
My date does return in the format M/D/YYYY. How do I change the formula to reflect this?- keArts
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to convert a date string into a true date?
I tried the IsDate to check if the string argument can be converted to a date - the result came back True. When I tried the Date it gave me an error message Bad Date Format String.- keArts
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to convert a date string into a true date?
I have a date field (4/8/2010 M/D/YYYY) that is in a string. I need to converet it into a date field. I have tried the following: StringVar DT := {Prt.Prt_Registration_Date}; NumberVar YR := Val (Split (DT , '/')[3]); if YR < 50 then YR := YR + 2000 else if YR < 1000 then YR := YR + 1900...- keArts
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
