Skip to Content

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

Date parameter conversion issue

Hi,

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

Thanks

Former Member
replied

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

**FRLDATE*

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

3.Create another formula ,

stringVar a;//year

stringVar b;//month

stringvar c;//day

a:=totext(right({@frlDate},2));//year

b:=left(mid({@frlDate},3),2);//month

c:=Left({@frlDate},2);//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