Getting Current Date MINUS 'X' Days

[Noman Jaffery]

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

[Michele Pinti]

Do you want the 70 days based off the system date when the query is run?

[Noman Jaffery]

Yes,

That would be the system date. Any ideas?

Noman Jaffery

[Michele Pinti]

date - (interval '070' day)

[Noman Jaffery]

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

[Mohammad T. Hussain]

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-

[Andreas]

Please do not cross-post.

Therefore topic locked. Thank you.