Re: help with date format

[Joe Patton <jpatton@RELTECCORP.COM>]

The SQR date input variable is looking for MM/DD/YYYY, MM-DD-YYYY, or
MM.DD.YYYY.  On your last try, you entered a valid date(01-17-1999) as far
as the SQR date field was concerned.  It looks like you made it past the
SQR program's type checking on the last try, but you received an Oracle
error.  I would check the 'NLS_DATE_FORMAT' setting on your database or
client software.  Your Oracle native date format may be defaulting to
'DD-MON-YY', so a valid SQR date input variable might not be valid when the
program executes a query and uses the date variable.

Joe Patton
RELTEC Corporation




Aboukr Sadikh <bsadikh@YAHOO.COM> on 04/08/99 01:55:24 PM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Joe Patton/LLP/RELTECCORP)

Subject:  help with date format




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