It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,011
×359

question asked: Jun 08 '16, 6:03 a.m.
question was seen: 1,495 times
last updated: Jun 08 '16, 10:02 a.m.

Related questions

How to take year from date in JRS advance SQL query?

0
Shubhangi yadav (13●2●8) | asked Jun 08 '16, 6:03 a.m.
Hi Team,

How to take year(YY) from full date(DD/MM/YY) in JRS advance query??

I have tried to take by using year() function of SQL but it is throwing error as invalid identifier.




Thanks in advance!!
Comments
Clara Forero commented Jun 08 '16, 10:02 a.m.
JAZZ DEVELOPER

Hi Shubhangi,

I just tried YEAR(CREATION_DATE) in Report Builder (RB) 6.0.2, using DB2 and it worked.  What RB version and what database vendor are you using ?

Thanks,
Clara

Be the first one to answer this question!

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.