Joined: 10 Mar 2008
Location: United States
Online Status: Offline
Posts: 1
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.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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.
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>
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
IP Logged
