Solved

Crystal Report 9.0 Date Range String

Posted on 2009-04-09
9
308 Views
Last Modified: 2012-05-06
I have a date and time value (String) that looks like this:

02/01/2005 08:49:04
I would like to display only field DateValue (TICKETDATE [1 to 10] in {?receivedDate} to {?EndDate} and it keeps bringing back an error DateRange required over {?ReceivedDate} and {?EndDate}

I would like the display to show dates begining 10/01/2008 - 03/31/2009

Please Help
0
Comment
Question by:cdmccoy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 24110984
Are the parameters date types?

mlmcc
0
 

Author Comment

by:cdmccoy
ID: 24111004
String Datetime.  
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24111049
There is no type like that.
So is one of them a string abd the other a datetime?

If so you will have to convert the sting to a date also

mlmcc
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:cdmccoy
ID: 24111090
Exactly -- I need to convert the string to a date

The data when I pull the field it shows 02/01/2005 08:49:04 format
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24111124
Your formula seems to be doing that.  You may need to convert one of the parameters also in the same way.

mlmcc
0
 

Author Comment

by:cdmccoy
ID: 24111213
Let me explain better.  The database field is in a datetime format 02/01/2005 08:49:04 format.  I would like to pull a select criteria for it to look for records, TICKETDATE >= '10/01/2008" TO TICKETDATE <= '03/31/2009'

It displays an error message "Bad Date Format".  When I try --> DateTimeValue {TICKETDATE} [1 TO 10]), It again states that I have a bad date format.  Please Heeelp.  What am I doing wrong.  The field TICKDATE is a string.
0
 

Author Comment

by:cdmccoy
ID: 24115440
Would someone please assist me if you can?  I know it's a holiday.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 250 total points
ID: 24116684
If you are hardcoding try this
Your ticket date is a date or datetime filed not a string
Date({TicketDate}) IN Date(2008,10,01) to Date(2009,3,31)

If you are using parameters make the start and end date DATE type and use
Date({TicketDate}) IN {?startdate} to {?enddate}

If ticketdate is a string then
Date(Val(Mid({TicketDate},7,4),Val(Mid({TicketDate},1,2),Val(Mid({TicketDate},4,2))  IN Date(2008,10,01) to Date(2009,3,31)

mlmcc
0
 

Author Comment

by:cdmccoy
ID: 24117487
Thank you sooooo much this one worked for me... Date({TicketDate}) IN Date(2008,10,01) to Date(2009,3,31).  Did I explain it incorrectly the first time?  You got it on the first try.....
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question