topic Date format in Application Development and Automation Discussions

Date format

Former Member — Sat, 07 Apr 2007 05:22:12 GMT

Hi Experts,

I have to selection scren parameter as p_gjhar like mkpf-gjhar.

I wanna reduce the fiscal year by one year in the select stmt.

select * from mkpf

into i_mkpf

where gjhar = p_gjhar - 1( one year less than the selection screen input)

plz let me know how to solve the issue.

regards

alson.

Former Member — Sat, 07 Apr 2007 05:26:27 GMT

p_gjhar = p_gjhar - 1.< or take it in another variable and pass that to select statement>

select * from mkpf

into i_mkpf

where gjhar = p_gjhar.

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

Former Member — Sat, 07 Apr 2007 05:28:43 GMT

Hi Alson,

In the program, before select statement, use the following code:

p_gjhar = p_gjhar - 1.

select * from mkpf

into i_mkpf

where gjhar = p_gjhar.

Best regards,

Prashant

learnsap — Sat, 07 Apr 2007 05:33:45 GMT

Hi Alson,

Before the select statement...

p_gjahr = p_gjahr - 1.

will solve the problem.

Regards,

Ramesh S

*Award points if reply is helpful