topic Re: selection options with dates in Application Development and Automation Discussions

selection options with dates

Former Member — Fri, 05 Oct 2018 07:52:22 GMT

Hallo Experts,

I have a requirement to put the last date of the last month as a second option in the selection option or let us say as a parameter e.g:

Today is 05.10.2018 so this parameter should be 30.09.2018.

and so on...

please your advice to do this

Jenie

Re: selection options with dates

fikretsomay — Fri, 05 Oct 2018 08:52:07 GMT

Hello,

You can achieve this by using events (INITIALIZATION etc.)

To calculate the last day of a month use this FM: LAST_DAY_OF_MONTHS

Fikret.

Re: selection options with dates

matt — Fri, 05 Oct 2018 09:24:24 GMT

Don't use select options for dates. You'll notice that SAP standard reports rarely use them - instead they use two parameters; one for start one for end, though often in the same row. See my blog here: https://blogs.sap.com/2014/02/07/dates-and-select-options/

There are many many questions with good answers concerning making date calculations. You really should search before asking questions.

Re: selection options with dates

Jean_Sagi — Fri, 05 Oct 2018 14:00:49 GMT

A manual approach would be something like:

Use the date parameter you have and write 01 to the day. So if you have 05.10.2018 you convert it to 01.10.2018.
Subtract 1 from the new date. Having 01.10.2018 subtracting 1 form it yields to 30.09.2018. That is what you need.

It should work for any date.

BTW: Have in mind mr. Billingham comment. His blog are very insightful.

J.