Eliminating "time" from date field in a Crystal Report

Epicor ERP 10
1

We are moving from E9 to E10 and using some of our existing custom Crystal Reports. When several of our Crystal reports print in E10, the date field appears as MM/DD/YYYY AND 12:00:00AM. (In the E9 output, 12:00:00AM does not appear.) Is there a way to eliminate the time portion of the date field from appearing in the E10 printout?

I’ve tried to change the date format in Crystal to “System Default Short Format” or even “MM/YY”. The date format does change, however, the time portion of the date still remains on the resulting output. Has anyone run into and solved this issue before?

Thanks in advance.

2

I have seen this happen also and came to the conclusion it had to do with Crystal version to report mismatch.

A older report started do this when I upped the Crystal developer version and updated the report. Same Epicor version.

Interested to see what others input is for this issue.

Brad

3

We dealt with this with many of our reports moving from E9 to E10. What version of Crystal is being used?

In Crystal Reports 2008

  • select the field
  • right-click
  • select format field
  • select Date and Time tab
  • select a date style from the list (we usually go with ‘03/01/1999’); there is a sample section below the list box that shows a preview of what the date should look like

Also, ensure the date field is of type DateTime or Date. If it is a string, the data source may need updating.

I hope this helps!
Thanks
Curt

4

ACurt,

Thanks for the feedback. We are using Crystal Reports 8. I had already tried what you suggested. I can see that the Sample preview section is MM/DD/YYYY (or any of other selections), but when the report is run, it produces MM/DD/YYYY and 12:00:00AM.

The second part of your suggestion “Also, ensure the date field is of type DateTime or Date. If it is a string, the data source may need updating.”. Where should I check that? In Epicor or Crystal?

Thanks,
-Rick

5

In some cases I’ve replaced date field(s) with formula(s).
e.g.
ToText({BAQReportResult.JobOper.StartDate},“MM-dd-yy”)

1 Like
6

We are having the same issue, although so far it seems to work to just change the time format. The problem I have is that this keeps popping up on more reports, and I’m wondering if I can just change the “System Default Short Format” to something other than “M/D/YYYY H:MM:SS[AP]M” once and have it fix it everywhere rather than this whack-a-mole approach of fixing every individual field instance whenever somebody spots it.

I looked in Company Configuration but didn’t see anything about time formats (but there are a LOT of tabs and I didn’t look under all of them), nor did I see anything under Company Maintenance or Site Config or Maintenance. What is “System Default Short Format” referring to anyway? Where is it defined? Hopefully it’s not specific to the machine the user is printing from, as that would really have the potential to mess things up!

7

Web page not available
It is the windows default and I believe specific to the user printing report

Vinay Kamboj