Solved

Crystal Report 9.0 Date Range String

Posted on 2009-04-09
9
304 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
  • 5
  • 4
9 Comments
 
LVL 100

Expert Comment

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

mlmcc
0
 

Author Comment

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

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
 

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 100

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 100

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now