Active TopicsMemberlistSearchHelpRegisterLogin

Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Change Date to Quarter ( Q1,Q2 etc Post Reply Post New Topic
Author Message
Ralphie
Newbie
Newbie


Joined: 08 Aug 2008
Location: United States
Online Status: Offline
Posts: 1
Quote Ralphie Replybullet Topic: Change Date to Quarter ( Q1,Q2 etc
    Posted: 20 Aug 2008 at 10:49am
I have been able to add a grouping by quater for the current year.
My data spans multiple years and would like to identify them by quarter also.
When using a range, (01/01/2007 in 03/31/2007)
I receive the error: date range is required here.
 
Any suggestions ? Confused
 
thanks
 
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Aug 2008 at 1:45pm
I think the problem is that the dates are in string format and they need to be a date data type. You can convert strings to dates using the CDate() function.
 
I cover all the Crystal Reports functions, and show how to use them, in three chapters of my Encyclopedia book. 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
keval300
Newbie
Newbie
Avatar

Joined: 18 Jul 2008
Location: India
Online Status: Offline
Posts: 24
Quote keval300 Replybullet Posted: 21 Sep 2008 at 11:31pm
Dear Mr.Brian,
 
I am sorry..
But Is this site to help others or for your  book marketing?
according to me ,Y I have joined this site is for sharing my knowledge.
But you have mentioned to read your book.for readuing your book they will have to buy your book.
 
Isnt it crazy....
 
what about the people who cannot Afford your book?
 
Hope I make sense some where.
 
Regards
Keval raj
Enjoy...
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.