Convert String to Date in Tableau using DATEPARSE

0 votes
In Tableau, I'm attempting to convert the text "10/20/22 04:30:21" into a short date field. I'm having trouble figuring out how to implement the "DATEPARSE" format correctly. Is there anyone who can assist me?
Mar 17, 2022 in Tableau by Vaani
• 7,070 points
8,071 views

1 answer to this question.

0 votes

You should be able to make the field a Date type and then present it as a short date using the built-in date formatting option. If Tableau isn't recognising the field as a date type, right-click it in the left-hand pane and choose Change Data Type, then Date. Right-click on the field in the left-hand pane and choose Default Properties -> Date Format to acquire the abbreviated date format.

Here's an example of how to use DATEPARSE:

DATEPARSE('dd-MM-YY', [myDateField])
answered Mar 28, 2022 by Neha
• 9,020 points

Related Questions In Tableau

0 votes
1 answer

How to convert string to date format in Tableau?

You can create the following calculated field: Dateparse('EEE ...READ MORE

answered Jun 30, 2018 in Tableau by ffdfd
• 5,550 points
6,392 views
0 votes
1 answer

Is it possible to merge year, month and date in Tableau?

Remove all the date pills and drag ...READ MORE

answered May 10, 2018 in Tableau by ffdfd
• 5,550 points
1,532 views
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
• 860 points
2,703 views
0 votes
1 answer

Tableau - Convert string from date

Hi Ayushi, 1.You can convert a date field ...READ MORE

answered Apr 22, 2019 in Tableau by Cherukuri
• 33,030 points
1,470 views
0 votes
1 answer

Parsing a string to a date in JavaScript

The best string format for string parsing ...READ MORE

answered Feb 18, 2022 in Java by Aditya
• 7,680 points
626 views
0 votes
4 answers

How can we compare dates in java?

public static String daysBetween(String day1, String day2) ...READ MORE

answered Sep 5, 2018 in Java by Sushmita
• 6,920 points
1,329 views
0 votes
1 answer

How can one day be added to a date?

One possible solution could be using calendar ...READ MORE

answered Jun 8, 2018 in Java by Daisy
• 8,140 points
609 views
0 votes
1 answer

How can I calculate number of days between two dates?

You may refer this. This might work ...READ MORE

answered Jul 19, 2018 in Java by Akrati
• 3,190 points
1,218 views
0 votes
1 answer

How to convert days(ex: Monday, Tuesday, etc) in string data type to day type in Tableau?

To create a date from constituent integers, ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 9,020 points
652 views
0 votes
1 answer

How to fix spelling error in a field or column value using Tableau?

You should be able to use a ...READ MORE

answered Mar 10, 2022 in Tableau by Neha
• 9,020 points
753 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP