Crystal Reports date format in formula string

Writing Code
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code

Topic: date format in formula string

Author	Message
t_sakthy Newbie Joined: 12 Sep 2007 Location: India Online Status: Offline Posts: 1	Topic: date format in formula string Posted: 13 Sep 2007 at 12:13am
	how do specify the date format in formula field?
	IP Logged

jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432	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. www.CustomReportWriters.net
	IP Logged

danmir Newbie Joined: 15 Jul 2007 Location: Mexico Online Status: Offline Posts: 6	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...
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.012 seconds.