Forum Discussion

etrietsch's avatar
etrietsch
Frequent Visitor
7 years ago
Solved

GENERATESERIES() function limited to 32766 rows?

Hi,   The following code only generates 32766 rows. Is this a restriction to the function or table, or am I doing something wrong?   Dates = GENERATE(GENERATESERIES(1;60815); VAR days = ...
Need Help
  • etrietsch's avatar
    etrietsch
    7 years ago

    UPDATE:

     

    The table did have more than 32766 rows, but after 32766 the date didn't change anymore. The problem looks to be the DATE() function which can't handle a 'day' value larger than 32766...? 

     

    After changing the code all was fine. The new code is:

    Dates = 
    GENERATE(GENERATESERIES(1;datediff(date(1880;1;1);now();DAY));
    VAR days = [value]
    Return ROW("Dates"; DATE(1880;1;1)+days))

    Thanks for the help!

etrietsch's avatar
etrietsch
Frequent Visitor
7 years ago

UPDATE:

 

The table did have more than 32766 rows, but after 32766 the date didn't change anymore. The problem looks to be the DATE() function which can't handle a 'day' value larger than 32766...? 

 

After changing the code all was fine. The new code is:

Dates = 
    GENERATE(GENERATESERIES(1;datediff(date(1880;1;1);now();DAY));
    VAR days = [value]
    Return ROW("Dates"; DATE(1880;1;1)+days))

Thanks for the help!