Hi,
I a date conversion issue. I am extracting the dates from sql server. The dates are in dd/mm/yyyy format. But when I get the tables into Tableau, it is automatically converted in mm/dd/yyyy format, so when I take the Date column in pane, all I am getting is January month.
How do I change the date format so that Tableau reads all the months from January to December?
Thanks,
Manil
Feb 11, 2019 6:20 AM
Your images are too small to read
please post your twbx workbook so we can see what is going on
Jim
Hello Manil,
Right click the Date field that is in the rows section and click on "More" in the date part section and select "year month day" part that will show the respective dates.
Please let me know in case of any issues.
Please mark the answer as helpful and correct if it resolves your question.
Thanks!
Sankar M
Hi Sankar,
I still can’t resolve the issue as I don’t see Year Month day part when I follow your instruction.
Would you mind updating my attached workbook, so how I see the correct results.
Thanks,
Manil
Feb 11, 2019 6:42 AM
you are coming out of SQL
I think this would work - it is brute force but give it a try and let me know - recast the date as a string and then try this
makedate(int(split([Date],'/',3)),int(split([Date],'/',2)), int(split([Date],'/',1)))
it returned this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Feb 11, 2019 6:53 AM
sure
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Jim,
Still I am getting January only for the months and other months are missing. My actual dates are in mm/dd/yyyy format.
Thanks,
Manil
I did few things a shown below in screenshots
1. change date fields to discrete and exact date
2. change defualt properties to date fields.
Hope it works for you.
Hi Arvind,
It’s better than what I was doing before but it still doesn’t solves my problem of showing all the months when I building viz.
Thanks,
Manil
Sorry i got your issue.
No matter what you do, the dates are formatting as above, and month is shown January. It is Odd
Date is randomly changing format form DD/MM/YY to MM/DD/YY
This is one of the similar issue like yours.
