Load current month data with do while

[MarioCenteno]

I am using a do while to try to bring data for the current month, but only upload data until the previous month I need your help please.

/* >> LOADA DATA PER PERIODS ========================================= */

LET vPeriodo = (YEAR(TODAY())) & '0'; // CURRENT A YEAR

LET vMesActual = NUM(MONTH(TODAY())); // CURRENT ACTUAL

LET vMesProximo = NUM(MONTH(TODAY())+1); // NEXT MONTH

LET vI = 7; // INITIAL MONTH

DO WHILE vI <= vMesActual

LET vCiclo = vPeriodo & vI; // BUILD YEAR-MONTH

TRACE $(vCiclo);

LET vCiclo = vCiclo & '01'; // BUILD YEAR-MONTH-FIRSTDAY

LOAD

SELECT * FROM TABLE

WHERE DATE =  TRUNC(LAST_DAY('$(vCiclo)'))

LET vI = vI + 1;

LOOP;

[petter · Accepted solution]

Sorry - I was a bit quick... the code should be like this instead:

vDate = Date(Date#('20180701','YYYYMMDD'),'YYYYMMDD');   
DO WHILE vDate <= Today(1)  
  /* TRACE */ SELECT * FROM TABLE WHERE DATE = TO_DATE('$(vDate)','YYYYMMDD');   
  LET vDate = Date( vDate+1 ,'YYYYMMDD');  
LOOP 

[MarioCenteno]

Thanks for responding, I have corrected and it works but it only loads 52 clients and they are approximately 10K.

Because it will be that it does not charge every day, there will be a way to load it with daily and keep it in the table

I need your help please.

[petter]

I think I have answered your question. Wouldn't it be better to pose a new question about your additional challenge. You could simply use the title "How to do incremental load" and refer to this thread.

I would appreciate if you mark this thread as answered - then you could continue getting help by me or others on the new thing on a different thread. OK?

[MarioCenteno]

Okay, Petter, I appreciate all your time I'll ask another question about this.