Yes, indeed. I had it set like that. Anyway, that is the format used for the calendar, but I has no impact in the variable content (and thus, in the set analysis expression) whatsoever. Thanks a lot, anyway.
I had a good search online and found this, I think it is what you are looking for.
Hopefully that works for you lol
mpineiro, I've been struggling with a similar problem to you and have finally got a solution that works for me.
I have a Calendar object using my variable Dt and in the Number tab I used the Format Pattern DD/MM/YYYY
I have selected 15/05/2017 using the Calendar object and Variable Overview shows this variable to be 42870
In my case I'm using Count against a unique key SeqNo so...
Now, we both know that we need to replace the 15/05/2017 part with $(Dt) so we get...
We know this does not work as Dt is 42870 so we need to format it using Date($(Dt)). In order to get the Date function to work inside the set analysis we need to use dollar expansion $(=Date($(Dt)))
So the final expression becomes...
So we're dollar expanding the Dt variable and we're dollar expanding the Date expression.
I hope that works for you.