CR8.5 - Formula Field - How to Format in DSR to a Short Date?

Posted on 2003-02-19
Medium Priority
Last Modified: 2012-05-04
I am writing a DSR report that has a formula field in the Detail section.  This formula field is called @dteEnrolled and is referenced in the associated form where it is set to a field from the Access 2000 database.  The field in the database is set to a short date.  When the report prints it displays a date and 12:00:00AM as the time.

I have another formula field in the report called @DiaryDate.  I created another formula field called @dteDiary and edited this formula to use the Date({@DiaryDate}) and referenced @dteDiary in the form and this provides me with the correct formatting.

Is there a simpler way of doing this?  I have tried modifying the properties for @dteEnrolled but they seem to have no effect.

I am kinda committed to using formula fields in the DSR and referencing their values to database fields in the associated FORM.

Thanks and be blessed,
Question by:wdsnead
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
LVL 101

Expert Comment

ID: 7984061
I haven't done this with a dsr but in CR with the report file you can format the fields

Select the field
Right click on it
Select format
Select Custom
Set the format as you desire


Author Comment

ID: 8019048
Thanks, mimcc, but as listed in my posted question I have already tried this without the desired changes.

Be blessed,
LVL 101

Accepted Solution

mlmcc earned 800 total points
ID: 8023124
When you tried changing the propeties was that on the field in the report or on the formula?

I change the date format all the time using the report field propeties and custom formats.  Are you sure what you have is a date field or is it a string that DATE() converts?

CR has the ability to convert date-time fields to date only fields.  Try this

Open the report
Set the convert date-time field to TO DATE

LVL 101

Expert Comment

ID: 8023126
If those ideas don't work what are the formulas?  Maybe they can be changed to get what you want.


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question