Link to home
Create AccountLog in
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
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Ganesh Vijaykumar
Ganesh Vijaykumar

ASKER

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

Thanks,
G