01-16-2013 10:57 AM
Sometimes the ******** shows up because the display columns are to narrow to display the 10 characters of the formatted result. If you can create a wider column to display the values that could correct the issue. You don't mention where you are seeing this so only a guess.
01-16-2013 11:58 AM
The column is wide enough. I am in the query builder and I click on a date field and it gives me the option to change format. Presently, there is nothing in the format and the results show 01MAR2013:00:00:00. I want to show 3/1/2013 but when I choose one of the other date formats, all I get is ****** no matter how big the column.
01-16-2013 12:58 PM
Here are some to try on for size:
Beyond that, you have more date-related formatting options with a DATE variable, which you can get by running the data through Query Builder and calculate a new column with the DATEPART() function.