Author |
Message |
Noman Jaffery Principal Member


Joined: 26 May 2005
            Posts: 176 Location: Melbourne, Australia

|
Posted: Thu Oct 27, 2005 2:15 pm Post subject: Getting Current Date MINUS 'X' Days |
|
|
Hi All,
I have a table with Customer ID and Transaction Date. Now the customer IDs can be repeated quite a few number of times. I want to create an object in the universe that would filter out those Customer IDs who did not have any transaction for the Last 70 days. Is there some easy way implement this? I am using BO 6.5 with Teradata V2R6.
Thanks!
Noman Jaffery |
|
Back to top |
|
 |
Michele Pinti Forum Enthusiast


Joined: 17 Jun 2002
               Posts: 1475 Location: Dayton, Ohio

|
Posted: Thu Oct 27, 2005 3:47 pm Post subject: Re: Getting Current Date MINUS 'X' Days |
|
|
Do you want the 70 days based off the system date when the query is run? _________________ Who's Your Friend? Search is Your Friend™
Infoview XI 3.1 SP3
Full Client Business Objects 5.1.6
Repository: SQL Server 2000 Database: Teradata 2.6
Michele Pinti
Standard Register Co.
|
|
Back to top |
|
 |
Noman Jaffery Principal Member


Joined: 26 May 2005
            Posts: 176 Location: Melbourne, Australia

|
Posted: Fri Oct 28, 2005 4:46 am Post subject: Re: Getting Current Date MINUS 'X' Days |
|
|
Yes,
That would be the system date. Any ideas?
Noman Jaffery |
|
Back to top |
|
 |
Michele Pinti Forum Enthusiast


Joined: 17 Jun 2002
               Posts: 1475 Location: Dayton, Ohio

|
Posted: Fri Oct 28, 2005 8:34 am Post subject: Re: Getting Current Date MINUS 'X' Days |
|
|
date - (interval '070' day) _________________ Who's Your Friend? Search is Your Friend™
Infoview XI 3.1 SP3
Full Client Business Objects 5.1.6
Repository: SQL Server 2000 Database: Teradata 2.6
Michele Pinti
Standard Register Co.
|
|
Back to top |
|
 |
Noman Jaffery Principal Member


Joined: 26 May 2005
            Posts: 176 Location: Melbourne, Australia

|
Posted: Fri Oct 28, 2005 12:16 pm Post subject: Re: Getting Current Date MINUS 'X' Days |
|
|
Michele,
Thanks for the reply. I tried your suggestion but it is not working I have posted my problem description at the following link:
http://www.forumtopics.com/busobj/viewtopic.php?p=236800#236800
Would appreciate if I can guided in the right direction. Thanks!
Noman Jaffery |
|
Back to top |
|
 |
Mohammad T. Hussain Principal Member


Joined: 21 Sep 2004
             Posts: 115 Location: Houston, Texas

|
Posted: Fri Oct 28, 2005 12:45 pm Post subject: Re: Getting Current Date MINUS 'X' Days |
|
|
Hello Noman,
try to use this code see if it works.
transaction date Not >= (Today-70), please let if this one doesn't work.
M- |
|
Back to top |
|
 |
Andreas Forum Advocate


Joined: 20 Jun 2002
              
*2 Posts: 17328 Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***

|
Posted: Fri Oct 28, 2005 1:35 pm Post subject: Re: Getting Current Date MINUS 'X' Days |
|
|
Please do not cross-post.
Therefore topic locked. Thank you. _________________ Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate |
|
Back to top |
|
 |
|