topic Re: Between Date issue in App Development

Between Date issue

Siraj — Mon, 20 Dec 2021 21:05:46 GMT

Hi,

I need to generate some information between two dates, Please refer the below example help me to achieve the same

example

Tool Id	Assign Date	Running Date
1234	5-Mar-20	30-Dec-20
5678	10-Dec-20	12-Feb-21

I want result like this

Tool ID	Running Month
1234	Mar-20
1234	Apr-20
1234	May-20
1234	Jun-20
1234	Jul-20
1234	Aug-20
1234	Sep-20
1234	Oct-20
1234	Nov-20
1234	Dec-20
5678	Dec-20
5678	Jan-21
5678	Feb-21

Thanks in advance

Siraj

Re: Between Date issue

Frank_Hartmann — Fri, 19 Feb 2021 15:29:42 GMT

Try this:

TEST: LOAD * INLINE [ RunningDateolID, AssignDate, RunningDate 1234, 05/03/2020, 30/12/2020 5678, 10/12/2020, 12/02/2021 ]; NoConcatenate tmp: LOAD RunningDateolID, Date(AddMonths(AssignDate,IterNo()-1)) as AssignDate, Date(AddMonths(AssignDate,IterNo()-1)) as RunningDate Resident TEST While AddMonths(AssignDate,IterNo()-1) <= RunningDate; Final: Load *, Date(RunningDate,'MM/YYYY') as DateNew Resident tmp; DROP Tables TEST,tmp

Re: Between Date issue

Siraj — Sun, 07 Mar 2021 10:35:25 GMT

Thanks Frank,

This logic works perfectly

Thanks

Siraj