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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quick and simple string to date conversion

Status
Not open for further replies.

robros

Programmer
May 22, 2001
241
US
Help me I need a formula that will convert a srting data type to a date.

Thank you in advance for you help..
 
DateValue ({date.field}) will work if your string is in any of the following formats. There may be more, these are formats that I've tested.

Dec 31, 1999
December 31,1999
12,31,1999
12/31/1999
1999,12,31

Let me know if you format differs from one of these.




Mike

 
If you have an older version of CR, I have a not-so-simple alternative in faq149-243. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top