Skip to Content
0
Former Member
Jun 07, 2010 at 08:41 PM

ORA-01861

83 Views

Hi forum.

I have a WebI report that has many queries around it but, it has 2 date filters with it used as prompt values in WebI (not in the universe). The thing is that the dates are correctly formatted, even that i checked myself that i used the same sentence (to_date) to convert them, but, when ia put them as filters one of them launches this error: ORA-01861 literal does not match format string.

Does anyone have any idea why it is this error launching?

I have also an idea, but i don't know it is posible. Can I use the dates for the 1st filter as values for the second one and the user has just to input just 2 dates and not 4?

Thanks,

Reynaldo