topic Re: How to split date in Application Development and Automation Discussions

How to split date

1190_5939_439 — Mon, 01 Mar 2021 08:13:51 GMT

Hi Experts

Now I met the below date issue.

For exmple: I input date query condition(20210201 to 20210228).

I hope I get 6 column values . [20210228.20210227.20210226.20210225.20210224.(20210201 to 20210203)].

How do I do it ?

Re: How to split date

joltdx — Mon, 01 Mar 2021 08:54:20 GMT

Hi! I don't understand what is is you want and what logic you need for it...

What do you mean with "6 column values"? What does columns have to do with this? Do you want dates, strings, ranges, or what?

And which logic should be used to determine the dates (or values) to return? The last 5 dates from the input in descending order, and then the first tree dates, ascending, as a string? or as a range?

Re: How to split date

1190_5939_439 — Mon, 01 Mar 2021 09:48:49 GMT

In ALV display I hope I get last 5 dates value and the other values(6 column values).

I want dates for it . Ascending as output is ok .

Re: How to split date

Sandra_Rossi — Mon, 01 Mar 2021 13:36:27 GMT

Oh you mean (20210201 to 20210223). (not 20210201 to 20210203) i.e. 6 buckets, first 5 buckets = 5 last days + last bucket for the rest of days.

Re: How to split date

Sandra_Rossi — Mon, 01 Mar 2021 13:39:09 GMT

With all dates being of type D, including SELECT-OPTIONS s_dates:

date1 = s_dates-high.
date2 = s_dates-high - 1.
date3 = s_dates-high - 2.
date4 = s_dates-high - 3.
date5 = s_dates-high - 4.
date6 = s_dates-high - 5.
title6 = |{ s_dates-low }-{ date6 }|.