Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date parameter conversion issue


I have to convert a user input date DDMMYY (Number) to YYYYMMDD(DECIMAL or NUMBER).

The user enters the date in the input screen in ddmmyy and it is compared in selection criterion with a database field

which is yyyymmdd format.

Both are of type number. Please let me know how to achieve this


Former Member

Hi Shalu,

Use the Following Steps:

1.Firstly,Create a parameter field with a type,Number.

2.To remove all space's and thousands delimiter In the parameter field ,write a formula


Replace(totext{?parameter name},"##"),",","").

3.Create another formula ,

stringVar a;//year

stringVar b;//month

stringvar c;//day




"19" & (a) & "/" & (b) & "/" & (c);

Hope,this helps you .

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question