Date char logic

[Former Member]

I have two date characteristics.

1) Created date

2) Contract start date

My requirement is report should pick all records where create date is after the contract start date.

Pls help

Ajay

[Former Member]

Bhanu can you explain me more clearly.

Thanks

Ajay

[tom_francis2]

There is an how-to:

How to replace a charateristic with it's values.

Use this how-to to make a key figure from your characteristic. With this key figure you can do all your conditions.

kr,

Tom

[former_member188975]

Hi Ajay,

Here is the document that Tom is talking about:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to calculate with attributes

This talks about pulling somethign from master data, but you will have to follow a similar procedure to get your dates as key figures.

Hope this helps...

[Former Member]

I created two restricted keyfigures with contract start date and created on.

Then i created a formula which has the boolean operator >. But it didnt work.

Can u explain if you know any other way to get this done.

Thanks

Ajay

[former_member188975]

Hi Ajay,

I think you will have to create 2 formula variable with replacement path and pull in the dates as key figures. Then you can do a comparison.

Hope this helps...

[Former Member]

Hi,

You can create characteristic variable on the 2 dates and then create a formula

create date > contract start date

then you can have a condition on this formula to pick valid records..

Ashish..