Home » Developer & Programmer » Forms » Getting error ORA-01847:day of month must be between 1st and last day of month
Getting error ORA-01847:day of month must be between 1st and last day of month [message #379186] Mon, 05 January 2009 05:21 Go to next message
h_jitendras
Messages: 36
Registered: October 2006
Member
Hi,
I have Date as a database field,also I have added it as a column in my form.
I have specified its format as FXMM/DD/YYYY..but when I enter the date in this format(or for that matter any format) it gives the above mentioned error.

Any thoughts please?
Re: Getting error ORA-01847:day of month must be between 1st and last day of month [message #379247 is a reply to message #379186] Mon, 05 January 2009 12:10 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-01847 day of month must be between 1 and last day of month

Cause: The day of the month listed in a date is invalid for the specified month. The day of the month (DD) must be between 1 and the number of days in that month.

Action: Enter a valid day value for the specified month.

It appears that you, actually, DID something wrong. Could you provide a sample test case? It would contain CREATE TABLE statement, as well as a FMB file attached to your message. Also, tell us which values you tried to enter and got an error message.

Though: what happens if you remove FX from date format mask?
Previous Topic: Open new Form and Exit this Form
Next Topic: Populating three data blocks with two 1:N relationships
Goto Forum:
  


Current Time: Fri Dec 09 11:38:13 CST 2016

Total time taken to generate the page: 0.08870 seconds