Solved

Crystal Report 9.0 Date Range String

Posted on 2009-04-09
9
307 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 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

739 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