Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone,
i have this api that needs a date to get the data from it and i want it this url to get the date auto for the next day
i was using this
LET vStartDate = Num(Date#('01-10-2023', 'DD-MM-YYYY'));
LET vEndDate = Num(Date#('15-10-2023', 'DD-MM-YYYY'));
FOR vDate = $(vStartDate) TO $(vEndDate)
LET vStart = Date(vDate, 'YYYY-MM-DD');
LET vEnd = Date(vDate + 1, 'YYYY-MM-DD');
.....
LET vUrl = vUrl & '&start=' & Date(vStart, 'YYYY-MM-DD');
LET vUrl = vUrl & '&end=' & Date(vEnd, 'YYYY-MM-DD');
LET vUrl = vUrl & '&page=1';
LET vUrl = vUrl & '&Accept=text/json';
next vDate
i have the data till the date (15) but i want when i load the data to get the next day without editing the date by hand everytime
anyone can help me with this?
and when i do this
LET vStartDate = Date#('01-10-2023', 'DD-MM-YYYY');
LET vEndDate = Date#('31-10-2023', 'DD-MM-YYYY');
FOR i = 0 TO vEndDate - vStartDate
LET vCurrentDate = Date(vStartDate + i, 'YYYY-MM-DD');
LET vStart = vCurrentDate;
LET vEnd = vCurrentDate + 1;
next i
i get an error i get to the new date like 16 but i get an error after how to stop it