-
1. Re: convert string to date,help me
Hi Mai,
Could you attach the workbook for reference.
Thank you.
Best Regards,
M.R
-
2. Re: convert string to date,help me
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
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
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
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 McClellan
Nov 21, 2018 9:05 PM
What's the format of your date currently ?
-
8. Re: convert string to date,help me
Please post your sample input date format and expected output.
-
9. Re: convert string to date,help me
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
Try this:
DATE(LEFT([Str Date],4)+"-"+MID([Str Date],5,2)+"-"+RIGHT([Str Date],2))
