RE: [sqr-users] Edit mask

["Peter Burton" <Peter_Burton@hyperion.com>]

All,

The default date edit mask for Oracle is 'DD-MON-YY'.  Given the year
2000 issue, SQR was modified to print a Warning when a date mask was
encoutered with a two digit year (YY).  This warning can be disabled by
an SQR.INI setting ([Default-Settings]
OutputTwoDigitYearWarningMsg=False) or eliminated by using a date edit
mask with a four digit year (YYYY).

The choice is yours on how you want to solve this issue.

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
Of Mingazov, Maya
Sent: Monday, April 10, 2006 2:50 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Edit mask

All date in SQR.INI file are YYYY for the year.

Thank you,

Maya 

-----Original Message-----
From: sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org
[mailto:sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org] On Behalf
Of Larry Roux
Sent: Monday, April 10, 2006 2:43 PM
To: Mingazov, Maya; sqr-users@sqrug.org
Subject: RE: [sqr-users] Edit mask

Check your date formats in the SQR ini (or SQR unx) file.


Larry Roux
Syracuse University
lroux@syr.edu


>>> MMingazov@newsamerica.com 4/10/2006 2:38 PM >>>
Yes, it is, but all I have on that line is:
"print &GFIFilmOfferExpirationDate        (  ,{TAB70})"

Maya 

-----Original Message-----
From: sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org 
[mailto:sqr-users-bounces+mmingazov=newsamerica.com@sqrug.org] On Behalf
Of Bob Stone
Sent: Monday, April 10, 2006 2:33 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Edit mask

I'm gonna go out on a limb and suggest it happens on line 812 of your
SQR.


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Mingazov, Maya
Sent: Monday, April 10, 2006 1:26 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Edit mask

Hello,

I am getting following error when trying to run sqr report:

"
Warning on line 812:

(SQR 7501) Using YY edit mask from (DD_MON_YY) against (2006)
"

Does anyone know where this edit mask is specified?
Any help?

Thank you,


Maya 


This message and its attachments may contain legally privileged or
confidential information.  It is intended solely for the named
addressee.  If you are not the addressee indicated in this message (or
responsible for delivery of the message to the addressee), you may not
copy or deliver this message or its attachments to anyone.  Rather, you
should permanently delete this message and its attachments and kindly
notify the sender by reply e-mail.  Any content of this message and its
attachments that does not relate to the official business of News
America Incorporated or its subsidiaries must be taken not to have been
sent or endorsed by any of them.  No warranty is made that the e-mail or
attachment(s) are free from computer virus or other defect.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 


This message and its attachments may contain legally privileged or
confidential information.  It is intended solely for the named
addressee.  If you are not the addressee indicated in this message (or
responsible for delivery of the message to the addressee), you may not
copy or deliver this message or its attachments to anyone.  Rather, you
should permanently delete this message and its attachments and kindly
notify the sender by reply e-mail.  Any content of this message and its
attachments that does not relate to the official business of News
America Incorporated or its subsidiaries must be taken not to have been
sent or endorsed by any of them.  No warranty is made that the e-mail or
attachment(s) are free from computer virus or other defect.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


This message and its attachments may contain legally privileged or
confidential information.  It is intended solely for the named
addressee.  If you are not the addressee indicated in this message (or
responsible for delivery of the message to the addressee), you may not
copy or deliver this message or its attachments to anyone.  Rather, you
should permanently delete this message and its attachments and kindly
notify the sender by reply e-mail.  Any content of this message and its
attachments that does not relate to the official business of News
America Incorporated or its subsidiaries must be taken not to have been
sent or endorsed by any of them.  No warranty is made that the e-mail or
attachment(s) are free from computer virus or other defect.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited.

Internet communications are not secure and Hyperion does not, therefore, accept 
legal responsibility for the contents of this message nor for any damage caused 
by viruses. The views expressed here do not necessarily represent those of 
Hyperion.

For more information about Hyperion, please visit our Web site at 
www.hyperion.com



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users