Error when trying to use date functions

[Manu0521]

Hi All,

I am trying to use the date functions to get the current year in my data item and I get this error when I validate my data item
CURRENT_DATE(), Sysdate() ,Year(date)...etc..  and my source data for the report is package published through TM1.

RSV-VAL -0010 Failed to Load the report specification XQE-CON-0007 XQE error encountered :XTM-CON -0001. An attempt to login to the TM1 server failed. The TM1 error code is : SystemServerNot Found. The TM1 error message is : SystemServerNotFound. Admin host :null Server Name : Null

And if I use Current_date instead of current_date() it returns me the date with out error . Can anyone explain me what is the problem.

Thanks,

[MFGF]

Hi,

If I was doing this, I would use the extract() function to extract the year from the current date, ie:

extract(year, current_date)

Does this give you the result you need?

MF.

[Manu0521]

Yes, that gives me the result, but wanted to know why I am not able to use other date functions.
Thanks,

[bi4u2]

Because current_date is a Cognos function while the other ones are database specific. TM1 is not Oracle or SQL so you would get an error.

[karthik12345]

i am facing same problem if we want month in string format(i.e jan) how can i get that
if i use extract(month,current_date),iam getting '1' but instead of 1 i want to show 'jan'
how can i get this?

Thanks,
Karthee

[BigChris]

This might help:

http://cognostips.weebly.com/blog/month-name

[karthik12345]

thanks BigChris,
   But it also showing same error.

Thanks,
Karthee

[BigChris]

Hi Karthee,

What error are you you getting? Did you see Manu0521's comment:

And if I use Current_date instead of current_date() it returns me the date with out error