Error msg - ORA-01843: Not a valid month 1

[Mack2]

Hi Everyone,

When you run a report based on a Oracle database, we receive the following error message;
ORA-01843: Not a valid month
Any ideas where this is coming from?
Thanks for any help you can provide!

 

[zemp]

Might be the date format. For example the date is dd/mm/yy and your regional settings (or crystal) are looking for mm/dd/yy. This way the 23rd (day) would be interpreted as a month and comes back as invalid.

zemp

 

[Mack2]

Thank you, I will try it. Would I right click on the date field, and change the format right in the shortcut menu?

 

[bmpsu]

I had a similar issue. Are you entering a date as a parameter field?

That was my case and I had to enter my date in this format:
yyyy-mm-dd

OR
If you are using a SQL command for your report and defining which date to use in your SQL; I think you could either use 'yyyy-mm-dd' or (ex.)'12-DEC-00'.

I am not too familiar with Oracle, but this was how I got around the error you are getting.

You could also use the 'to_date' function in your SQL:

WHERE date = to_date('2002/12/18','yyyy/mm/dd')