Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Future Dates in SQLBI Date Table Question

I am using SQLBI's Date Template. I cannot figure out how to have the template include future years up to 2024. Below is where I think the change needs to be made but I cannot make it work. Thank you...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi Anonymous ,

In your scenario, you only need to change the line 10 to the floowing one:

VAR LastYear = 2024

Please refer to the result:

Best Regards,

Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

When I enter 2024 on line 10 I get this error. If I have that line blank the table works. Am I missing something?

Thanks,

  Sarah