🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
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
1
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

1 Answer

0
Votes

The same as in Excel, a date is actually stored as a number. Wrap any Tableau date in the FLOAT() function and you’ll see it convert to a number.