Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

change table visual column data type

Hi, The table visual has a startdate which I would like to chage th eformat of. How do I do this please? At present it is i.e. in format of 14 july 2019 I would like it changed to 14/06/2019   ...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

     

    Changing Format settings is only changing the way you display the data and its not impacting the model, so you don't need to worry, on the other hand changing the Data type would impact the model and you would have to reload if you wont to revers the change.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

In the field section, select your date column and do the following



Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This I believe hs to be done in the dataset?
    Then should I click on refresh?

    And then I will be able to use the new date format in desktop so that it can be used in table visual?

    Thanks

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      Hi Anonymous 

       

      Changing Format settings is only changing the way you display the data and its not impacting the model, so you don't need to worry, on the other hand changing the Data type would impact the model and you would have to reload if you wont to revers the change.

       

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      Mariusz Repczynski

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        In th eformat menu, I see two options

        1-

        *14/03/2001

        2-

        14/03/2001

        What is the difference please?