Change Date to Quarter ( Q1,Q2 etc
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4047
Printed Date: 03 May 2024 at 6:28am
Topic: Change Date to Quarter ( Q1,Q2 etc
Posted By: Ralphie
Subject: Change Date to Quarter ( Q1,Q2 etc
Date 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 ?
 thanks
|
Replies:
Posted By: BrianBischof
Date 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 http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - 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> |
Posted By: keval300
Date 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... |