Format SSAS Dates from '1900-01-01 00:00:00.000' to '01/01/1900'
Steps:
1. Add a Varchar Date to your Data Source View
1. Add a Varchar Date to your Data Source View
go into your data source view
right click on your date tables header
create a new named calculation
make a new varchar date
2. In your date Dimenision, Add your new field as the NameColumn on your datetime field.
Find the date you want to change
View it's properties
Find the date you want to change
View it's properties
Change the namecolumn field , add your new field.
Format SSAS Dates from '1900-01-01 00:00:00.000' to '01/01/1900'
All of the formatting of date functions in SSAS just plain don't work. The hack is.....