There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source

Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.