How to convert datetime format to date format in crystal report using C#?

c# crystal-reports
ratty picture ratty · Jul 16, 2010 · Viewed 196.9k times · Source

i am working c# windows form application and also in crystal report.i am retriving the date from database in datetime format but i like display date only in report,Is any formula field in crystal report help for me for this problem.Thanks in Advance.

Answer

Nathan Koop picture Nathan Koop · Jul 18, 2010

If the datetime is in field (not a formula) then you can format it:

  1. Right click on the field -> Format Editor
  2. Date and Time tab
  3. Select date/time formatting you desire (or click customize)

If the datetime is in a formula:

ToText({MyDate}, "dd-MMM-yyyy")
//Displays 31-Jan-2010

or 

ToText({MyDate}, "dd-MM-yyyy")
//Displays 31-01-2010

or 

ToText({MyDate}, "dd-MM-yy")
//Displays 31-01-10

etc...

Related questions

Could not load file or assembly CrystalDecisions.ReportAppServer.ClientDoc

I've looked at similar questions on SO, but nothing quite matches my issue as far as I can tell. The exception message: Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one …

Read More
How to bind crystal report to manually created DataSet

I wan't to create DataSet from code and set it as data source for crystal report. I don't want to create a DataSet xsd file in VS if I don't have to. Just pure code. DataSet ds = new DataSet(); DataTable …

Read More
CrystalReport Load report failed

I have a windows application project (C# and .NET 2.0) that used Crystal Report 2008. But I get error sometimes (it seems accidentally) in loading report. That error is: CrystalDecisions.Shared.CrystalReportsException: Load report failed. System.Runtime.InteropServices.COMException (0x8000020D): Unable …

Read More