Cognos Techical Discussions

Saturday, 9 November 2013

How do we get the Last month last working day in Cognos?


Cast ([As Of Date], date) =_add_days (_first_of_month (?AsofDate?),-1).
Posted by Unknown at 10:10
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2013 (12)
    • ▼  November (12)
      • Sorting Month column when it is in Jan, Feb Mar …....
      • How to calculate percent change for months
      • How to Use a Prompt Macro to Dynamically Select a ...
      • Using Prompt Macro for Optional and/or Required
      • How to add additional column titles into a list
      • Hiding a list or crosstab by using a render variable
      • Scrolling data from Right to left in Report studio
      • Converting months into Quarters.
      • Cognos Controller
      • How do we get the Previous Month Sales Data?
      • How do we calculate MTD, YTD in cognos
      • How do we get the Last month last working day in ...

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.