Print Page | Close Window

Supressing Time

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2509
Printed Date: 06 May 2024 at 11:50am


Topic: Supressing Time
Posted By: cfrey
Subject: Supressing Time
Date Posted: 04 Mar 2008 at 5:58am
I have the following function to print a date range:
dateadd("M",-11,(minimum(LastFullMonth))) & " to " & maximum(LastFullMonth)

The dateadd portion of the function includes the time:

3/1/2007 12:00AM to 2/29/2008

How do I supress the time?

Thank you for your help.


Replies:
Posted By: rahulwalawalkar
Date Posted: 04 Mar 2008 at 7:35am

Hi,

use the following
 
DATE(dateadd("M",-11,(minimum(LastFullMonth)))) & " to " & maximum(LastFullMonth)
 
Cheers
Rahul
 

Posted By: cfrey
Date Posted: 04 Mar 2008 at 10:58am
That was it. Thank you for your help.


Print Page | Close Window