The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

How is the date format interpreted in Tableau?

How is the date format interpreted in Tableau?

0
Votes
0
Answer

Subject: How is the date interpreted in Tableau?
While completing the Intro to Tableau course, I reached the exercise section and noticed that the date of purchase column has numbers that I can’t interpret, however Tableau is able to. For example:
On the worksheet ‘audiobook sales’ for the column titled date of purchase, the value in one of the cells is ‘42935’.
On Tableau after converting the column to ‘date’ instead of ‘number’, it reads ’19/07/2017′.
The transaction ID matches so I am sure that this is the same value (7553710).
Could you let me know your thoughts on this when you’re free?
Thanks,
Mek

No answers so far.