Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 427
  • Last Modified:

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

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,
David
0
wdsnead
Asked:
wdsnead
  • 3
1 Solution
 
mlmccCommented:
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

mlmcc
0
 
wdsneadAuthor Commented:
Thanks, mimcc, but as listed in my posted question I have already tried this without the desired changes.

Be blessed,
David
0
 
mlmccCommented:
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
Click FILE --> REPORT OPTIONS
Set the convert date-time field to TO DATE

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

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now