Formula variable for a user input DATE value

[Former Member]

Hi All,

I want to create Formula variable for a user input DATE value as I need to use it in a formula to compare between user entry date & date in the DSO. Does any body has any idea about it?

I tried to create formula variable with manual entry but then I am not getting DATE option.

Regards,

Sonal

[Former Member]

Hi ,

You have to create a formula variable in the formula.

The formula variable in the general tab would have the reference characteristic as your date characteristic on which you have created a user entry variable or on which you intend to create a date entry variable.

Give the proceesing type as replacement path.

Next in Replacement path mention you would replace the variable with value of another variable.

Mention the variable name.(This is the actual varaible created on the selection screen),

Also mention you would replace only from value/to value of the variable.

Check the following help link

[Replacement path type formula variable|http://help.sap.com/saphelp_nw70/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm]

Hope this helps,

Best regards,

Sunmit.

[Former Member]

Hi Sunmit,

But I can not use replacement path as I need user entry but with user entry date input is not possible in formula variable

[Former Member]

Hi Manesh,

It is possible.

Read the thread careully.

Formula variable cannot be input ready, but the variable used for replacement of the formual variable can be input ready.

Here you actually replace the formula variable with another variable ie input ready and the formula variable would read the input ready variable.

Follow the steps mentioned above.You should be through

Hope it helps,

Best regards,

Sunmit.

[Former Member]

Thanks Sunmit ,

I understood what u r saying but could u plz explain this step by step

[neelesh_jain3]

There is no option of date for formula variable.

Cheers,

Neel.

[Former Member]

Thanks for Reply but I wanted to know is there any work around for this?