1 of 1 people found this helpful
So looks like DATENAME is fully supported on your live connection...
Do Alias' work
Here's I've used DATEPART('weekday' [Date]) to bring back the weekday number. I can then go into this field a change the Alias for each of 1-7
and I get this
I think that should work, as the Alias is a local tableau feature, so should be datasource support independent.
Thanks for your response Mahfooj. This approach fixes the problem as long as data it is in extract mode.
Thanks Simon. The alias approach is working for me.