-
1. Re: Date Issue
Jim DehnerFeb 11, 2019 6:20 AM (in response to Manil Wagle)
Your images are too small to read
please post your twbx workbook so we can see what is going on
Jim
-
2. Re: Date Issue
Manil Wagle Feb 11, 2019 6:25 AM (in response to Manil Wagle)Hi Jim,
I have attached the workbook.
Thanks,
Manil
-
Date.twbx 11.0 KB
-
-
3. Re: Date Issue
Sankar M Feb 11, 2019 6:28 AM (in response to Manil Wagle)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
-
4. Re: Date Issue
Manil Wagle Feb 11, 2019 6:38 AM (in response to 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
-
Date.twbx 11.0 KB
-
-
5. Re: Date Issue
Jim DehnerFeb 11, 2019 6:42 AM (in response to Manil Wagle)
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.
-
6. Re: Date Issue
Manil Wagle Feb 11, 2019 6:48 AM (in response to Jim Dehner)Hi Jim,
Do you mind attaching the workbook.
Thanks,
Manil
-
7. Re: Date Issue
Jim DehnerFeb 11, 2019 6:53 AM (in response to Manil Wagle)
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.
-
Date_v10.2.twbx 26.5 KB
-
-
8. Re: Date Issue
Manil Wagle Feb 11, 2019 6:59 AM (in response to Jim Dehner)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
-
-
10. Re: Date Issue
Manil Wagle Feb 11, 2019 7:56 AM (in response to arvindgarg)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
-
11. Re: Date Issue
Vaishnavi krishnan Feb 11, 2019 8:11 AM (in response to Manil Wagle)-
Date.twbx 54.0 KB
-
-
12. Re: Date Issue
arvindgarg Feb 11, 2019 8:48 AM (in response to Manil Wagle)which visualization are you building?
-
-
14. Re: Date Issue
Vaishnavi krishnan Feb 11, 2019 9:18 AM (in response to Manil Wagle)Date is randomly changing format form DD/MM/YY to MM/DD/YY
This is one of the similar issue like yours.