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?

Report message to a moderator

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: 21823
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?

Report message to a moderator

Previous Topic: Open new Form and Exit this Form
Next Topic: Populating three data blocks with two 1:N relationships
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 10 02:24:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.