I have a DateTime column in my cube. This actually just contains DATE - the time component is always 00:00:00
How do I set formatting on this column so it shows up only as MM/DD/YYYY and ignores the HH:NN:SS portion of the column? I want to set this in the cube so that any client that connects to the cube get the same format and I do not have to go around formatting the column for each client.