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!
Convert String to DateTime
- Thread starter vespin
- Start date
RobertKaiserIII
Programmer
Yes, there is a Crystal function that does this.
Write your formula this way:
If IsDate(StringField) then // Checks if the string can be converted to a date
CDate(StringField); // Converts the string
The CDate function is pretty smart and can translate many different formats, but if it doesn't work for your format, tell me how the string is formatted and we can try to manually convert it.
Write your formula this way:
If IsDate(StringField) then // Checks if the string can be converted to a date
CDate(StringField); // Converts the string
The CDate function is pretty smart and can translate many different formats, but if it doesn't work for your format, tell me how the string is formatted and we can try to manually convert it.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question