I guess so the above suggestion works. I had never come across a question mark output before so thought didn't understand it.
But if I include -1 then it give me the day before my min date (e.g. 19th from my inline load)
If I remove the -1 then it starts on the actual first date.
So is -1 really necessary?
And what does FieldValueCount('OrderDate') do? I think it create a pool of distinct dates in the table which we later use for Min Max variables. If I put Autogenerate 1; instead, it will not work because it only has the min field?
Sorry if I am asking stupid questions I am trying to understand the whole picture of this new technique