Solved

Cognos promp dates

Posted on 2014-01-01
3
271 Views
Last Modified: 2014-01-31
Hi,

I developing a report which requires to read from balance table it gives yesterday value which is fine, but I want also to read balance one day before.

what is the expression to use? or is there any other way or shortcut?

Thank you.
0
Comment
Question by:amq10
  • 2
3 Comments
 
LVL 12

Expert Comment

by:Habib Pourfard
ID: 39750164
we need more details. please let us know about the query you are using.
0
 

Accepted Solution

by:
amq10 earned 0 total points
ID: 39751187
thank you Pourfard.

the query I want to run is like this as I drag from package data items:

customer number
customer name
account balance amount  ( I expect output to show balance as yesterday which is fine)
account balance amount  -1 Day ( not included package data items).

I hope this can help.
0
 

Author Closing Comment

by:amq10
ID: 39823520
it works with some tricks
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Syntax for query to update table 2 39
Trouble with <> 2 26
Need return values from a stored procedure 8 40
SQL - Simple Pivot query 8 26
Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question