Skip to content

Instantly share code, notes, and snippets.

@BBischof

BBischof/date_id_2_date

Created August 22, 2018 19:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save BBischof/02e076c7642a6caf3650483582a82491 to your computer and use it in GitHub Desktop.
Save BBischof/02e076c7642a6caf3650483582a82491 to your computer and use it in GitHub Desktop.
Download ZIP
Tableau Magic to cast Date_Id to a convenient date format, assumed YYYYMMDD
Raw
date_id_2_date
DATE(DATEADD('day',[date_id] % 100 - 1,
DATEADD('month', INT(([date_id] % 10000) / 100) - 1,
DATEADD('year', INT([date_id] / 10000) - 1900,
#1900-01-01#))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment