help with date format

[Aboukr Sadikh <bsadikh@YAHOO.COM>]

Hi Guys,

I have tried different ways of entering the date, but it looks like any
of the formats is
recognized as a valid date format. Can the problem be an installation
one??
Thanks in advance for your hints.

BS.

***************************************************************************************
Please press ENTER (Do not input a value):
Report Began: 01:06:57
Update PaySheets with Pay Input Data

Enter Payroll Run ID: 902
There is more than on Pay Calendar for the Run ID.
You must identify the Pay Calendar.
Enter Company ID (e.g. ccb): cob
Enter Pay Group (e.g. sm1): gen
Enter Pay End Date (e.g. 15-Nov-89): 17-Jan-99
   (SQR 1943) The date '17-Jan-99' is not in one of the accepted
formats listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 17-JAN-99
   (SQR 1943) The date '17-JAN-99' is not in one of the accepted
formats listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 17-01-99
   (SQR 1943) The date '17-01-99' is not in one of the accepted formats
listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 17-01-1999
   (SQR 1943) The date '17-01-1999' is not in one of the accepted
formats listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 17-Jan-1999
   (SQR 1943) The date '17-Jan-1999' is not in one of the accepted
formats listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 1999-01-17
   (SQR 1943) The date '1999-01-17' is not in one of the accepted
formats listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 99-01-17
   (SQR 1943) The date '99-01-17' is not in one of the accepted formats
listed below:
        MM/DD/YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM-DD-YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        MM.DD.YYYY [BC | AD] [HH:MI[:SS[.NNNNNN]] [AM | PM]]
        SYYYYMMDD[HH24[MI[SS[NNNNNN]]]]

Enter Pay End Date (e.g. 15-Nov-89): 01-17-1999
(SQR 5528) ORACLE OFEN error 1843 in cursor 7:
   ORA-01843: not a valid month

Error on line 966:
   (SQR 3725) Bad return fetching row from database.

SQR: Program Aborting.

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com