Cognos Techical Discussions
Saturday, 9 November 2013
How do we get the Previous Month Sales Data?
if(?Previous?='Previous Month') then ([Date Field] between _first_of_month (_add_months (current_date,-1)) and _last_of_month (_add_months (current_date,-1))) else ([Date field] in_range ?DatePrompt)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment