Date Formats

[w1mnk]

I have a database wherein the date and time is stored as

yyyy-mm-dd hh:mm:ss.00 (note the "dash"es)

Is there a formula that I can use to convert the date to the Crystal format mm/dd/yyyy? I need to use a date range as a parameter. Any help is greatly appreciated. Thank you.

Jon

 

[synapsevampire]

Are you stating that this is a char/string?

If so, just convert it to a date in a formula:

datetime(left("2000-12-31 11:50:59.00",19))

Now you can just place the formula, right click and select format field and format however you'd like.

Performance would be improved by correcting this on the database side, but this should work.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com