Converting YYYY string to date format?

Question

Hi All,

I'm running into a snag with one of my workflows that publishes to tableau server directly.  I have a year field that is the result of transforming several columns and performing a LEFT function to pull out the year.  Is there an easy way to convert a string YYYY into a date.  I am fine with plugging in 01/01 or 12/31 as I am only reporting at the year level in tableau.

Thanks in advance for the help!

Example:

BenMoss · Accepted Answer

Yes, you can simply use a formula tool, creating a new field and select 'date' as the type then use something like.

[Year Field]+"-01-01"

IanCo · Accepted Answer

Hi Brad,

Yes. Use the formula tool and write: "01-01-"+[Year]. Combine that with a Select tool to change the Type to Date and you should be ready to publish to a tde.

Ian