Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, i'm stucking ni this simple situation where i need ta have bars from a date range (2014-now) but not all date have data in them, how do i generate a local autogenareted table with a date range? in Oracle i would do someting like this: SELECT (to_date(sysdate,'DD-MM-YYYY') - level + 1) AS day FROM dual CONNECT BY LEVEL <= (to_date(sysdate,'DD-MM-YYYY') - to_date('01-01-2014','DD-MM-YYYY') + 1);
Hi, you can try something like this:
LET vCalendarStart = Date('2014-01-01');
LET vCalendarEnd = Date(today());
LET vCalendarLength = Num(Date#(vCalendarEnd)) - Num(Date#(vCalendarStart)) + 1;
LOAD
Date($(#vCalendarStart) + RecNo()-1) AS Date
AutoGenerate $(#vCalendarLength);