-
1. Re: convert string to date,help me
mursid rahman Nov 20, 2018 6:01 PM (in response to Mai Mai)Hi Mai,
Could you attach the workbook for reference.
Thank you.
Best Regards,
M.R
-
2. Re: convert string to date,help me
Tanya Mamchik Nov 20, 2018 7:33 PM (in response to Mai Mai)Hi Mai,
DATEPARSE() function will do a job.
This article could be helpful: Convert a Field to a Date Field - Tableau
Hope that helps,
Tanya
-
3. Re: convert string to date,help me
Mai Mai Nov 21, 2018 5:25 AM (in response to mursid rahman)Hi MURSID RAHMAN,
The tableau on my machine does not have date functions. That's why I can not convert from string to date
Do you know why?
-
4. Re: convert string to date,help me
mursid rahman Nov 21, 2018 5:18 PM (in response to Mai Mai)Hi Mai,
Is by any chance your data source is from Tableau Server? That might be one of the reason. It is an easy fix. You just have to create a calculated field to convert the string field to a date.
I believe Tanya Mamchik has provided you with a link of a solution. If you need further assistance. You could provide the workbook that you are working on.
Regards,
M.R
-
-
6. Re: convert string to date,help me
Tanya Mamchik Nov 21, 2018 8:48 PM (in response to Mai Mai)Hi Mai,
Please see this forum thread (Dateparse function missing in 10.2 ) . Mursid Rahman was right about the data source connection.
Hope that helps,
Tanya
-
7. Re: convert string to date,help me
Chris McClellanNov 21, 2018 9:05 PM (in response to Mai Mai)
What's the format of your date currently ?
-
8. Re: convert string to date,help me
Ombir Rathee Nov 21, 2018 10:02 PM (in response to Mai Mai)Please post your sample input date format and expected output.
-
9. Re: convert string to date,help me
Mai Mai Nov 21, 2018 11:35 PM (in response to Ombir Rathee)Hi OMBIR RATHEE,
input_date = 20181101 is string
i use function : date(input_date) but output is null.
-
10. Re: convert string to date,help me
Ombir Rathee Nov 21, 2018 11:42 PM (in response to Mai Mai)Try this:
DATE(LEFT([Str Date],4)+"-"+MID([Str Date],5,2)+"-"+RIGHT([Str Date],2))