Split date and time from datetime field.

0 votes
How to divide "Date & Time" field into two fields "Date" alone and "Time" alone?
Apr 1 in Tableau by sindhu
52 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

Hi, 

Follow these steps to divide field into multiple fields. 

1. Create calculated field as date by using split function(). here [datetime] is my field name with datetime value.

   

   

You have to convert datetime to string to use split function on the datetime value.

Here index 1 indicates the first word or string before split and so on.

2. Now add these 2 column next to datetime field to see the date and time separately.

Hope this helps you.

answered Apr 1 by CHERUKURI
• 13,940 points

Related Questions In Tableau

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
73 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 9, 2018 in Tableau by Atul
• 5,470 points
19 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by Atul
• 5,470 points
25 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
• 830 points
46 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,200 points
945 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
36 views
+2 votes
1 answer
0 votes
1 answer

Date values from an int and a string in separate columns

Hi Anitha, You can combine fields together to ...READ MORE

answered Mar 13 in Tableau by CHERUKURI
• 13,940 points
26 views
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by CHERUKURI
• 13,940 points
48 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.