Forum Discussion
Solved
Date Separation - separating dates from timestamps
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 simp...
Edit your query, select your column, go to the Transform tab and change the "Data Type" to Date instead of Date/Time.
Column = Table[date].[Date]