Forum Discussion

amtanner's avatar
amtanner
Regular Visitor
10 years ago
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...
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

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

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

amtanner

 

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

 

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

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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