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

Shubhangi yadav

(13●2●8) 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!!

0 votes

Comments

Clara Forero

JAZZ DEVELOPER Jun 08 '16, 10:02 a.m.

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

0 answers

3,946 views

0 votes

Be the first one to answer this question!

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.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

usage

× 12,143

jrs

× 363

Question asked: Jun 08 '16, 6:03 a.m.

Question was seen: 3,946 times

Last updated: Jun 08 '16, 10:02 a.m.

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

Shubhangi yadav

Comments

Clara Forero

0 answers

3,946 views

0 votes

Be the first one to answer this question!

Follow this question

Question details

Related questions