BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Streamline and extend SAP BusinessObjects software 
Streamline and extend SAP BusinessObjects software (Opens a new window)  

General Notice: No events within the next 45 days.

Getting Current Date MINUS 'X' Days


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Noman Jaffery
Principal Member
Principal Member



Joined: 26 May 2005

Posts: 176
Location: Melbourne, Australia


flag
PostPosted: 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
Forum Enthusiast



Joined: 17 Jun 2002

Posts: 1471
Location: Dayton, Ohio



PostPosted: 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
Principal Member



Joined: 26 May 2005

Posts: 176
Location: Melbourne, Australia


flag
PostPosted: 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
Forum Enthusiast



Joined: 17 Jun 2002

Posts: 1471
Location: Dayton, Ohio



PostPosted: 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
Principal Member



Joined: 26 May 2005

Posts: 176
Location: Melbourne, Australia


flag
PostPosted: 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 icon_smile.gif 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
Principal Member



Joined: 21 Sep 2004

Posts: 115
Location: Houston, Texas



PostPosted: 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
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 16534
Location: Dreaming of Africa..


flag
PostPosted: 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: .. oops, no book at hand for now.. how unusual for me

Focusing on Data Visualization, SAP BI 4.0, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0448 seconds using 17 queries. (SQL 0.0027 Parse 0.0339 Other 0.0082)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo