Author Topic: Last day of the year appearing in the first week of the same year  (Read 3316 times)

Offline gurralakrishna

  • Full Member
  • ***
  • Join Date: Nov 2012
  • Posts: 20
  • Forum Citizenship: +1/-0
Hi All,

I am facing issue in cognos powerpaly transformer cubes.
The last day of the year getting in first week of the same year.I am using Sunday is my week first day and saturated is my week last day.but i need to populate last day of the year like 53 rd week or first week of the next year. 
example 2012/12/31 is populating in the first week of 2012.
My source is IQD from cognos 8 and week is a calculation like week_of_year(date)
I was checked all the options in model,but i could not find any solution.

could you please help.