Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Date Format in Parameter Prompt Post Reply Post New Topic
Author Message
ampierce
Newbie
Newbie


Joined: 10 Mar 2008
Location: United States
Online Status: Offline
Posts: 1
Quote ampierce Replybullet Topic: Date Format in Parameter Prompt
    Posted: 10 Mar 2008 at 8:28am
Hi all! I am new to the forum so please forgive me if this question has already been asked and answered, i tried a search but no results.
 
Is there any way to change the date format for a date parameter prompt?
It is currently showing yyyy/mm/dd, i would like it to show mm/dd/yyyy.
 
I tried changing my default preferences, but that seems to only change how fields are displayed within the report, not how the parameter prompt displays.
Thanks!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 11 Mar 2008 at 10:55am
I discuss this on page 195 of my book. CR uses the current locale for setting the date format. But it was buggy and they are supposed to fix it with a service pack (I haven't checked recently so see if they've done it, so you should download the latest SP and see what happens).

If it doesn't work, you can make the the parameter a string and use an edit mask to format it how you want ("00/00/0000" or whatever). Then use the Date() function to convert the string to a date in your record selection formula.

You can find out more tips and tricks about Crystal Reports in my book Crystal Reports Encyclopedia.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP 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.031 seconds.