Print Page | Close Window

date format in formula string

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1311
Printed Date: 02 May 2025 at 11:59pm


Topic: date format in formula string
Posted By: t_sakthy
Subject: date format in formula string
Date Posted: 13 Sep 2007 at 12:13am
how do specify the date format in formula field?Confused



Replies:
Posted By: jkwrpc
Date Posted: 13 Sep 2007 at 7:49am

Try creating a formula using:

 DateValue({datefieldname}).
 
I believe this will just return the date from the datetime field.
 
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net


Posted By: danmir
Date Posted: 14 Sep 2007 at 10:39am
Another one, if the result of the formula is a date, you can paste it in the report, and then just right click it, and go to the format menu, and then just simply choose the format you want to use...



Print Page | Close Window