converting a date field from an integer or a string to a date: Tableau Quickvids

Показать описание

**won't be needed in future versions (Tableau will automatically convert/ Video done in 9.1)

To convert integer use the following formula:
dateadd('day', int([Date]%100)-1,

(dateadd('month', int(([Date]%10000)/100)-1,

dateadd('year', int([Date]/10000)-1000,#1000-01-01#))))

For a string, use the following:
date(mid([DATE],5,2) + "/" + right([DATE],2) + "/" + left([DATE],4))

Tableau Brent

Рекомендации по теме

Комментарии

Thank you!!!! OMG - this was driving me up the wall with Tableau (Converting from Interger)

gdsglobaldatashare

Thanks for creating this video! It really helps me a lot

SuperJohncena

Gracias, me has ayudado mucho. Saludos.

Raquell_Quintanilla

Hi, I am trying to convert my string column that look like: APR 2015 to date.I tried function parsedate but I got 2010 January. I tried LEFT+RIGHT functions but it didn't help. Maybe you can help?

adiparag

Hey, i need some help :-). In my excel sheet i only have years. How can i convert it to be only a year, and not having months, quarters etc...?!

fairy

ha ha just spotted that this is for american date format!!

tighthead

Gang, check out the date functions within the tAbleau calculated fields dialog box.. there's a whole sleeve of functions within the DATA sub-library.. **if you don't see the section with functions on it to the right, click the expand arrow on the right side of the calculation box. There are examples with each function. Too easy.

tableaubrent

Can you explain why the bit of code that you shared transforms the integer into the date. It's nice to have working code to copy and paste, but I'm trying to work to a point where I can write code like this myself

Barber

converting a date field from an integer or a string to a date: Tableau Quickvids

converting a date field from an integer or a string to a date: Tableau Quickvids

Learn SQL: Converting non-date fields to Date/Time format

Databases: How to convert a datefield from string to date?

Salesforce: Convert Text to Date field

Converting Date Field to DateTime Field #inSalesforce

ACCESS Lesson 134 - Convert Date From 8 Digits to Date Fields

Databases: Oracle sqlldr convert date field with different NLS_DATE_FORMAT

Salesforce: Converting a text field to date or datetime

Converting AM/PM Text Fields into Dates with Oracle Analytics

SQL : Convert datetime field to just a date field in SQL (Oracle)

SQL : In SQL, how do I convert a date field into a string if null?

Salesforce: Converting a date field to date time in formula (2 Solutions!!)

SQL : How do you convert a decimal date to a date field in a where statement?

MySQL : query sql convert text field dd/mm/yyyy to date field yyyy-mm-dd

Salesforce: How to convert date/time field to date value?

5. Convert Date Time Field

R : R - converting date and time fields to POSIXct with HHMMSS format

Salesforce: Date field conversion to text for year (2 Solutions!!)

SQL : Sql Convert Text Field To Date Field

MySQL : convert date string to mysql datetime field

Converting VARCHAR to TIMESTAMP with milleseconds yields 'ERROR: date/time field value out of.....

WEM Tutorial: Converting String to Date - Resolving Date Type Field Issues (No Code/Low Code)

Wordpress: converting custom field date format (3 Solutions!!)

Salesforce: Wrong date when converting datetime value to date field