How do I remove the time from a formatted DateTime in Crystal Reports?

fixed the issue. Will look into that further In Crystal Reports XI Release 2 you can right click on the field and go to Format Field. On the "Date and Time" tab click the customize button. Under the Date Tab change the Date Type drop down to "Windows Default Long".

help you fix your problem .NET framework is surely needed if you plan to execute C# applications, there is a client profile with limited features but if you are not sure what developers will develop and deploy I would install the whole .NET framework.
for CR, I had lots of issues in the past and punctually missing dlls or missing components and clients unable to render or export reports. I would recommend installing the whole CR runtime package just to be on the safe side. 70 MB is not much nowadays.

wish of those help You may want to rethink grouping on a datetime field if you want it distinct down to the second; the chance that multiple records share the exact same datetime field are usually extremely low, negating the usefulness of grouping.
For this reason, CR may have taken the liberty of assuming you only wanted to group by the date instead of the full datetime value. You can check by performing the following steps: Select "Report" from the CR toolbar → "Group Expert" → Select your group on the right and hit "Options" → At the bottom of the "Common" tab there will be a dropdown labeled "The section will be printed". Verify that it says "For each second" instead of "For each day" or some other value.

this one helps. It turns out that you can use datediff("s", date("1970-01-01 00:00:00"), {date_column}) to get the unix time stamp in Crystal.

it helps some times Use this: CDbl(currency number). Theres a good document on Crystal Conversions: Type Conversion chart