RE: [sqr-users] Issue with convert function in Hyperion 8.5

["Peter Burton" <peter.burton@oracle.com>]

Maddy,

What platform are you running on?

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of maddy
Sent: Monday, October 22, 2007 6:04 PM
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions.
Subject: [sqr-users] Issue with convert function in Hyperion 8.5

(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 102 in cursor 28:
   [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Incorrect
syntax near '?'.
Error on line 1629:
   (SQR 3716) Error in SQL statement.
Errors were found in the program file.
SQR: Program Aborting.


Iam getting the above error while executing a SQR program using Hyperion 8.5.

convert(datetime,substring(convert(char(10), dateadd(mm, -1, $_gsTo_Date),101
+ '01' + substring(convert(char(10), dateadd(mm, -1,
$_gsTo_Date),101),6,5)) &FROM_DT


The same code works fine in Brio 6.2 . What could be the issue ? Why
is the above code working when I replace $_gsTo_Date with getdate().I
couldn't find the general syntax for convert () function in Hyperion
8.5.  Please advice.


Thanks!
Maddy

_______________________________________________
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