Avatar of Ganesh Vijaykumar
Ganesh Vijaykumar
 asked on

Calculating Day of the week - Cognos 10.2

Hello Experts,

I am a newbie to Cognos. I am using Cognos version 10.2.

I have a column named "Transaction_Date" in my data, using this i am trying to calculate "Day of the week"( i.e 1 is the first day of the week as indicated by the second parameter (1 to 7, 1 being Monday and 7 being Sunday).

I used the below mentioned syntax to get the results:

_day_of_week ([Time Metrics].[Transaction Date]],1)

But I am getting an error message as mentioned below:

Parsing error before or near position: 52 of: "_day_of_week ([Time Metrics].[Transaction Date]],1)"

I am clueless how to proceed further, since the syntax seems okay...

It would of great help if any one can help me to get the results.

Looking forward for the positive response!

Thanks,
Ganesh
DatabasesDB Reporting ToolsSQL

Avatar of undefined
Last Comment
Ganesh Vijaykumar

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Ganesh Vijaykumar

ASKER
Oh yeah I didn't realize it... Its working fine now...

Thanks,
G
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy