Hello A small issue here. Am getting this error when running a query on a table using a DATE field in the where clause. However this is happening on oracle database and not on another. ORA-01843: not a valid month The query is: Code (SQL): SELECT * FROM case_trials WHERE (date_of_trial BETWEEN '01/04/2008' AND '31/03/2009') AND (case_status = 'OPEN') TO_DATE functions round the statement resolves the error but i am just curious as to why i would get the ORA-01843: not a valid month error in one database but not in the other. Also i should mention that queries are run through Oracle Forms. Thanks in Advance!