Extended date table dynamic end date issues

[ysherriff]

Hi All,

I am trying to follow the tutorial on dynamic end date for my date table but running into an issue. I am using Melissa’s query. I am attempting to display only the date up to current date but getting an error. Can anyone help to see what I am doing wrong.

Thanks in advance.

[jps]

Hey @ysherriff

As the error says, its looking for 3 parameters however you are only giving it a year.

Here is how I would do. I created 3 separate queries from Blank query
1)

And then in the Calendar that invoked using m code I replace 3 parameters in the date function

Hope this helps.

[ysherriff]

Perfect. I was reading up on it just now and now it makes sense. Thanks JPS…