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

crystal-reports crystal-reports-2010
ProfK picture ProfK · Aug 11, 2013 · Viewed 24.4k times · Source

I have a date field (based on DateTime in .NET) in Crystal Reports. I go through a complex format dialog, set the day to be 0n, the month to me 0n, and the year to be None, desiring a date representation of dd/MM. What I get is dd/MM hh:mm:ssAM.

What do I have to do to get rid of the time portion? It is overwriting other columns in the report making it unreadable?

I am using SQL Server 2012 Enterprise.

Answer

Siva picture Siva · Aug 12, 2013

Use formula 

date(datetime field)

Related questions

Crystal Reports Exception: The maximum report processing jobs limit configured by your system administrator has been reached

I'm facing a very buggy issue, in ASP.NET application after viewing the same report many times simultaneously I got this exception: The maximum report processing jobs limit configured by your system administrator has been reached. Wait I know there …

Read More
crystal report field explorer not showing newly added field

I have created a crystal report with datasets(xsd) , it is working fine. Then i added a new field in xsd and when i open the field explorer it do not show that field, i added source again through database …

Read More
How to create Table in Crystal Report

Create Table in Crystal Report I am newbie to Crystal Report, and i am using Crystal Report 2008. I want to know, do we have table object in Crystal Report.. so that i can draw a table with specific rows and …

Read More