Showing posts with label Date. Show all posts
Showing posts with label Date. Show all posts

Monday, 31 October 2016

convert [year] column to date


convert [year] column from excel to date

DATEADD('year', INT([Year])-1900, #1900-01-01#)

https://community.tableau.com/message/235385

Thursday, 9 June 2016

Time durations - More/ less 24h

http://drawingwithnumbers.artisart.org/formatting-time-durations/

Transform string date to date format in Tableau


1. Duplicate the date dimesion (string)
2. Right click and "Change date type">>>> Date & Time  >> Ok
3. Right click and "Default Properties">>>> Date Format  >>  Custom >>> add "hh:mm:ss.000"