Forum Discussion

travbum's avatar
travbum
Advocate I
9 years ago
Solved

Visualization can't remove Time from Date

  I've split a column in to two parts, "CreatedDate" and "CreatedDate_TimeOnly". When I go to chart the "CreatedDate" it's still giving me times for the data. How do I remove this?     
Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

    This looks like formatting only. Go to the data view and change the format of the date column to exclude the time format

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi travbum,

     

    You should be able to change the data type of "CreatedDate" column to Date type and format it under Modeling tab by first clicking the column within your fields.:smileyhappy:

     

     

    Regards

DanielM80's avatar
DanielM80
Advocate I
7 years ago
I have the same issue but the format change didnt fix it. Any ideas?
Anonymous's avatar
Anonymous
Not applicable
7 years ago

DanielM80 Did you change the Data Type or just the Format?

  • DanielM80's avatar
    DanielM80
    Advocate I
    7 years ago

    both, but i figured it out last night. The x-axis was set to continious not to category... 

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks.  Fixed my issue after changing from Continuous to Category.

    • letsgohiking's avatar
      letsgohiking
      Regular Visitor
      5 years ago

      thanks you made my day!!!!

    • madison_jane's avatar
      madison_jane
      Regular Visitor
      4 years ago

      THANK YOU FOR POSTING THIS! I was losing my mind over here