convert character date to true date

[twes3]

Hello. How do I convert character date field (YYYYMMDD) to a true date field?

Thanks

 

[GJParker]

CDate(Left({MyTable.Field},4),Mid({MyTable.Field},3,2),Right({MyTable.Field},2))

Gary Parker
MIS Data Analyst
Manchester, England

 

[MisterMo]

use the date function in a formula

eg.
date({yourtable.datecharField})

then simply right click on the formula field and format as you see fit to any date format available.

just in case you should also put a check to make sure that it will always return a date

eg

if IsDate ({yourtable.datecharField}) = true then
date({yourtable.datecharField})


Mo

 

[MisterMo]

Sorry the isdate check and date option won't work without dividers on the string


Mo

 

[dgillz]

NumberToDate(val({YourYYYYMMDDfield}))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[GJParker]

dgillz

There is no NumberToDate function in CR10 is this new to CRXI ?

Gary

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

Try:

CDate(Val(Left({MyTable.Field},4)),Val(Mid({MyTable.Field},5,2)),Val(Right({MyTable.Field},2)))

-LB