Can anyone see anything clearl wrong with this script and why it appears to be treating my date as a string?
The code is creating a Weekend date based on a Thursday weekend. The logic is working but when I try to use this in a variable in set analysis it wont recognize it as a date even if I try to format it. But I created the same code converting to a NUM() and it shows the correct number for each date. In my set analysis I am using the max() function to create a variable of the max available week selected then I need to use that in set analysis to compare to the field below but it wont recognize it. No error, it just ignores it. Frustrating but I havent worked with date variables in quite a while.
Because you are using the Floor statement this is getting converted to an integer field. If you replace Floor with DayStart and remove the Num function this should return a date in your default date format.
Rather than relying on default formats though you can always force the format with a Date function. Wrap your entire statement in a Date function and it will cause it to display as you want it (remember that dates are only ever numbers - it's only how they display that changes). The code would be:
