Date Separation - separating dates from timestamps

[amtanner]

The data that I am using is importing as the following form "MM:DD:YYYY 00:00:00 __". (For example, "10/1/2015 12:00:00 AM".) I am not sure why it is doing this because the source of the data is simply in MM:DD:YYYY format. (I am importing this data from a SharePoint site, FYI.) How do I separate the date (MM:DD:YYYY) from the timestamp on the right side (00:00:00 __)? In the end, I am trying to zero in on the year, month, and quarter using a fiscal calendar but am unable to create the relationship between that calendar and the dates because of the timestamp attached. Suggestions?

[Anonymous]

Column = Table[date].[Date]

[v-sihou-msft]

@amtanner

Or you can use Format() function to remove the timestamp part.

Column = FORMAT(Table[date],"MM-DD-YYYY")

Regards,

[Anonymous]

Thank you!  This is exactly what I was looking for and is simple.

[Greg_Deckler · Accepted solution]

Edit your query, select your column, go to the Transform tab and change the "Data Type" to Date instead of Date/Time.