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!

Formatting DateTime Strings into Date field

Status
Not open for further replies.

rlockaby

Technical User
Jul 11, 2005
3
US
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,

 
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top