Last Modified Date: 15 Aug 2019
Environment
- Tableau Desktop
- JDE Julian Date Field
Answer
The following instructions can be reviewed in the workbook attached below.Create a calculated field to determine Julian years
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box:
- Name the calculated field. In the example workbook, the calculated field is named "Julian Year".
- In the formula field, create a calculated field similar to the following:
IF LEN(Julian JDE Date) = 6 AND LEFT([Julian JDE Date], 1) = '1' THEN '20' + MID([Julian JDE Date], 2, 2) ELSEIF LEN([Julian JDE Date]) = 5 THEN '19' + MID([Julian JDE Date], 1, 2) END
- Click OK.
Create a date calculated field that adds the number of days from the JDE Julian Date to the Julian Year field
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box:
- Name the calculated field. In the example workbook, the calculated field is named "Julian Date - Tableau".
- In the formula field, create a calculated field similar to the following:
DATE(DATEADD('day', INT(RIGHT([Julian JDE Date], 3)), DATE('01/01/'+[Julian Year])-1))
- Click OK.
Additional Information
The ability to automatically convert JDE Julian Dates to a supported date format is functionality that is not currently built into the product.Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials