Date Between

ambasadorknz — Thu, 22 Mar 2018 11:33:02 GMT

Hi,

I have some problem with check data in two tables..

Calendar:

DAY

2018/01/01

2018/01/02

2018/01/03

2018/01/04

Data1:

Start,End,Value

2017/10/01,2017/12/12,10

2017/12/12,2018/01/01/100

2018/01/01,2018/01/03/10

What i want to do is... check condition

if day is between Start and Sto then sum(Value)

It should looks like below table:

2018/01/01=110

2018/01/02=10

2018/01/03=10

2018/01/04=0

So Can You help me? Recommend some solution??

I need do all calculations/joins in Load statement

Can i prepare one table X From Calendar and Data1?

Re: Date Between

MK_QSL — Thu, 22 Mar 2018 11:36:31 GMT

check for intervalmatch() function

ambasadorknz — Thu, 22 Mar 2018 13:26:39 GMT

Thank You for Help...

I was looking for exactly that solution