deeejay

Tableau - Date Calculations

Mar 5th, 2015
515
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. CONVERT a NUMERIC FIELD INTO an actual DATE:
  2. DATEPARSE(“yyyyMMdd”, STR([DATE]))
  3.  
  4. Counting Days WITHIN a Dynamic DATA SET:
  5. MAX(DATETRUNC('day',[DATE TIME]))-MIN(DATETRUNC('day',[DATE TIME])) + 1
  6.  
  7. Subtract hours FROM DATE:
  8. DateAdd('hour', -4, [DATE FIELD])
  9.  
  10. Combine DATE AND TIME FROM two different FIELDS:
  11. DATEADD(
  12.     'hour', DATEPART('hour', [ORDER TIME]),
  13.     DATEADD(
  14.     'minute', DATEPART('minute', [ORDER TIME]),
  15.     [ORDER DATE]
  16.     )
  17. )
Advertisement
Add Comment
Please, Sign In to add comment