change table visual column data type

[Anonymous]

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

Thank you

[Mariusz]

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.

[Anonymous]

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 · Accepted solution]

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.

[Anonymous]

In th eformat menu, I see two options

1-

*14/03/2001

2-

14/03/2001

What is the difference please?

[Mariusz]

Hi @Anonymous 

I'm unable to answer this question, for me they are very much the same.

Maybe one of the admis will be able to answere this question.

Best Regards,
Mariusz

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

Please feel free to connect with me.

[Anonymous]

thank you