Formatting DateTime Strings into Date field

[rlockaby]

Using Crystal Developer 10.
As a new user, I am struggling to format a default DateTime String into a usable Date field. The default DateTime String field format is "2004-06-01T04:00:00". I need to convert this to a date field with a mm/dd/yy format.

Every default formula in the formula editor create errors.

I imagine this is a multi-step process...just don't know the process.

Thanks,

 

[synapsevampire]

What does the T represent within the datetime field example you posted, time?

Keep a constant spray of scalding Drano between your dba's eyes it's flowing readily from their ears in hopes of preventing her/he from ever being remotely involved with database design again.

Then use the following formula, perferrably typed in using the severed fingers of your dba stapled to her/his spinal cord:

cdatetime(replace({table.field},"T"," "))

Get the idea that I think this is a bad way to store data?

-k

 

[rlockaby]

I don't know why the T is in this field. It's a POS from start to finish.

Anyway, your formula worked! Thanks very much.

Ron

 

[rlockaby]

This formula removes the T from the DateTime string but I need to remove the Time as well. The result I'm looking for is mm/dd/yyyy.

Any ideas?

Thanks,

R