Last day of Next Year Using "Relative Date Ranges"

Questions & Answers
1

Hi guys,

I’m trying to show all 12 months of the current year and all 12 months of the next year in the report.

I found that “Add members for data range” can be set to be “first day of the current year and last day of next year”.

1

The first half of the command “first day of the current year” works fine, but the second half “last day of next year” does not work.

How can I get the last day of the next year in this syntax?

Is there any specific format?

Thanks.