Dates & Strings

[CNeeds]

I have a string field with a value of "19930419" in my database, in Crystal Report I need to reformat the string as 04/19/1993...Please help& suggestions...Thanks!!! Again, the field is not date field it is a String field.

 

[bdreed35]

It is best to convert it to a date data type in a formula so that you can use it in other formulas as a date, or format it however you like.

Try this in a formula:

cdate(val(left({table.date},4)),val(mid({table.date},5,2)),val(right({table.date},2)))

~Brian

 

[crystalreporting]

Or...

if NumericText(table.date)
then
NumberToDate(ToNumber(table.date))

Peter Shirley

http://www.linkcorp.com