help!! phaleeezz!! error message: Plan dates are invalid (SQL 2000)
-
i was just executing an update statement like this and that error occured.. it usually runs without error.. except for this specific data.. what does that "plan dates are invalid" mean? thanx in advance again!! UPDATE AJ_CONTRACTS SET EXPECTED_SIGNOFF = '06/20/2008', CONLEN = '20',EXTENDED = 'Y', CONLEN_UNIT = 'M', UPDATED_BY='apagustin', UPDATE_DATE ='10/25/2007' WHERE (CREW_SEQ_NO = '27979') :wtf:
-
i was just executing an update statement like this and that error occured.. it usually runs without error.. except for this specific data.. what does that "plan dates are invalid" mean? thanx in advance again!! UPDATE AJ_CONTRACTS SET EXPECTED_SIGNOFF = '06/20/2008', CONLEN = '20',EXTENDED = 'Y', CONLEN_UNIT = 'M', UPDATED_BY='apagustin', UPDATE_DATE ='10/25/2007' WHERE (CREW_SEQ_NO = '27979') :wtf:
I've not seen that error message before. Try:
- The date formats may be incorrect. Try using '20 Jun 2008' and '25 Oct 2007' instead.
- Double-check if there are any triggers defined on the table.
If these don't identify your problem then give us the exact error message (including error numbers). Regards Andy
-
i was just executing an update statement like this and that error occured.. it usually runs without error.. except for this specific data.. what does that "plan dates are invalid" mean? thanx in advance again!! UPDATE AJ_CONTRACTS SET EXPECTED_SIGNOFF = '06/20/2008', CONLEN = '20',EXTENDED = 'Y', CONLEN_UNIT = 'M', UPDATED_BY='apagustin', UPDATE_DATE ='10/25/2007' WHERE (CREW_SEQ_NO = '27979') :wtf:
Try swapping the date. 06/20/2008 to 2008/06/20
Illegal Operation Making Computer Software Talk
-
i was just executing an update statement like this and that error occured.. it usually runs without error.. except for this specific data.. what does that "plan dates are invalid" mean? thanx in advance again!! UPDATE AJ_CONTRACTS SET EXPECTED_SIGNOFF = '06/20/2008', CONLEN = '20',EXTENDED = 'Y', CONLEN_UNIT = 'M', UPDATED_BY='apagustin', UPDATE_DATE ='10/25/2007' WHERE (CREW_SEQ_NO = '27979') :wtf:
anthoy wrote:
SET EXPECTED_SIGNOFF = '06/20/2008',
You can try this as well: SET EXPECTED_SIGNOFF = cast('06/20/2008' as date) It will force the string into a date (you will need to do the same with UPDATE_DATE).
You always pass failure on the way to success.
-
anthoy wrote:
SET EXPECTED_SIGNOFF = '06/20/2008',
You can try this as well: SET EXPECTED_SIGNOFF = cast('06/20/2008' as date) It will force the string into a date (you will need to do the same with UPDATE_DATE).
You always pass failure on the way to success.
thanks for all the help guys.. i really appreciated it... my boss says its ok.. cause my data was just messed up or the field 'EXPECTED_SIGNOFF' was somewhat already filled in.. it was a 'trigger' on that table 'AJ_CONTRACTS' that was causing the error.. maybe you were all right it's just the date format.. cause i was using format date 'dd/mm/yyyy':rolleyes::rolleyes: