Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crystal Reports date parameter format vs. Oracle date format
SUCCESS! Thank you kskid! I played around with that to_date function for a while before, but could never get it to work. Your solution worked like a charm. Finally I can move on from this report... thanks again!- arock213
- Post #8
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Crystal Reports date parameter format vs. Oracle date format
Unfortunately I don't have access to the Oracle backend. Fortunately I did discover the "Show Field Type" option in Crystal, and it turns out that P_NASU_DT is in fact a String field. I created String parameters (from and to dates) in Crystal, and modified the Select statement appropriately...- arock213
- Post #6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Crystal Reports date parameter format vs. Oracle date format
kskid - thanks for looking into this the error I receive when using parameters as you describe is: ORA-01861: literal does not match format string I think the problem is that the Crystal parameter looks like 1/1/2008 and the Oracle database field looks like 2008-01-01, so they don't match up...- arock213
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Crystal Reports date parameter format vs. Oracle date format
Hello – long time reader, first time poster. I am working in Crystal Reports v11 with an Oracle db, and trying to use a Command to create a report. To my knowledge, I need to use a command because I am performing a UNION query. The problem is that the user would like to use a Date parameter...- arock213
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 4 Other topics
