Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: date format in a parameter field Post Reply Post New Topic
Author Message
alff
Newbie
Newbie


Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 3
Quote alff Replybullet Topic: date format in a parameter field
    Posted: 25 Mar 2008 at 9:17am
I am new to CR. I have made a parameter field of type "date". CR want to present this as a YYY-MM-DD.  My folks would like to have it presented as MM-DD-YY on input. I found a formula using Min and Max so the date shows up on the report correct. However the parameter does not. Does anyone know how I can get my parameter to input as MM/DD/YY?  
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Mar 2008 at 2:58pm
This has been discussed elsehwhere on this forum. You should probably search it for more info. Anyway, CR is supposed to use the local system data format, but it's buggy. They said they would release a service pack to fix it but I haven't checked if this is out or not. You should go to their site and see.

In my book I discuss making the parameter a string and using an edit mask of "00/00/00". Then use the CDate() function in your record selection formula.

You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
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
alff
Newbie
Newbie


Joined: 25 Mar 2008
Location: United States
Online Status: Offline
Posts: 3
Quote alff Replybullet Posted: 25 Mar 2008 at 3:09pm
Brian, I have not seen your book. However I have a question. Do you use coding examples in your book? For things like the "date format in a parameter field"  that I am asking about. I am certainly not against purchasing a good reference book. Thanks
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Mar 2008 at 9:29pm
Yes, for the majority of topics I discuss I like to show examples so that you can see how something works in practice. I show how to use the CDate() function on page 248 and I discuss your question on page 195 for my "Best of the Forum" questions.
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.