CODEWITHSUNDEEP
datetimetableau-api
Tony
Tony

Reputation: 9611

Tableau calculated field to subtract x hours

I have the calculated field which takes a millisecond formatted time and converts it into a standard date - my question is its in GMT time - how do I subtract 5 HOURS off of this? 

makedate(1970,1,1)+(int([last update dttm (FIELD NAME)]/1000))/(60*60*24)

Upvotes: 0

Views: 3194

Answers (1)

Bernardo
Bernardo

Reputation: 3348

This should work: dateadd('hour',-5,[date_field])

Upvotes: 2

Related Questions