2 Replies Latest reply on Nov 23, 2016 6:28 AM by Eoghan Lyons

    Calculated Field (Date) given individual components

    Eoghan Lyons

      I have a report which shows date as e.g. 2016-11-20, which when I connect via tableau can only recognise as a string, and I cannot convert to a date.

       

      Thankfully within the same excel sheet they have headings for "Sales Year", "Sales Month" and "Sales Day", all stored as #.

       

      When I try to generate a calculated field though using the following text, the result cannot be recognised as a date:

       

      DATE(([Sales Month])/([Sales Day])/([Sales Year]))

       

      Can anyone advise how I can use the 3 components, or additionally the date and time given I also have "Sales Hour" and "Sales Minute" in the spreadsheet also?

       

      Much obliged.

       

      Eoghan.