| Problem with Date [message #88276] |
Mon, 10 June 2002 08:11  |
Sonya
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hello everyone,
I need your help.
I have a date info saved in a table as CHAR.
When I am creating a report in query I convert it to:
to_date (Pick_Up_Date, 'RRRR-MM-DD') date_shipped
In the Parameter Form I need to have ability to specify dates between which the shippments were made.
So, in the query I specify
Pick_Up_Date =:hidate
and Pick_Up_Date = :lodate
Then I create two fields for hidate and lodate.
After I run the report I get :
Ora – 01861 literal does not match format string
And --> Pick_Up_Date=: lodate
Please help me to resolve this issue.
Thanks in advance,
Sonya
|
|
|
|
| Re: Problem with Date [message #88280 is a reply to message #88276] |
Tue, 11 June 2002 05:12  |
rama krishna
Messages: 97
Registered: December 2001
|
Member |
|
|
hii,
the problem may be in storing the date in the table.
see if it is in dd-mm-yyyy format then there is no problem....
and see that while creating the parameters they are of date format.... and convert those dates into the specified formats..
any clarification can revert back..
cheers
ram
|
|
|
|
| Re: Problem with Date [message #88285 is a reply to message #88276] |
Wed, 12 June 2002 21:43 |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
Hii Sonya,
You can give format to the date column in the query's condition , i.e,
" where to_char(pick_up_date,'RRRR-MM-DD') = to_char(hidate,'RRRR-MM-DD') "
Hope this will solve your problem.
Suraj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
