Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Tableau Magic to cast Date_Id to a convenient date format, assumed YYYYMMDD
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