[sqr-users] Issue with date format in SQR prog in hyperion 8.5

[maddy <madhudvm@gmail.com>]

Date        $gsTo_Date

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


The above function works perfectly in Brio 6.2 but doesn't work in
Hyperion 8.5.

If I replace the $_gsTo_Date with getdate() in the above function as
shown below, it works fine even in Hyperion 8.5.

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


Is the general syntax of convert function changed in Hyperion 8.5 ?
Can someone please send me the general syntax of convert function ?

Thanks!
Maddy

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