How to convert string to date format in Tableau?

0 votes

I want to parse the following string to date and time format in Tableau:

Wed Nov 18 20:22:45 +0000 2015

Any idea how to use calculated fields? Tableau using the calculated field and DATEPARSE function?

Jun 29, 2018 in Tableau by ghost
• 1,790 points
650 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can create the following calculated field:

Dateparse('EEE MMM dd hh:mm:ss Z yyyy', [YourString])
answered Jun 29, 2018 by Atul
• 5,470 points

Related Questions In Tableau

0 votes
1 answer

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 830 points
43 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,170 points
898 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
533 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
71 views
0 votes
0 answers

How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

Apr 10, 2018 in Tableau by ghost
• 1,790 points
70 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,550 points
1,051 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,470 points
64 views
0 votes
6 answers

How to use COUNTIF in Tableau?

I'll give you a brief idea on ...READ MORE

answered Dec 10, 2018 in Tableau by Haider
4,524 views
0 votes
1 answer

How to get Tableau results in python?

Well even I was looking for the ...READ MORE

answered Apr 9, 2018 in Tableau by Atul
• 5,470 points
38 views
0 votes
1 answer

How can I add legends to worksheet in Tableau?

Just add the worksheet on the dashboard ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,470 points
67 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.