I am currently running the following formula from Salesforce data currently being extracted to tableau online server:
IF CaseDate=DATE(Date-Time Edited) THEN 0 ELSE 1 END
However, we are in Australia and when the Date-Time Edited field occurs in the morning (Australian time). It appears to be adjusting time back to UTC and returning a date from the previous day.
Date-Time Edited in SF= 16/11/2017 9:58 AM
Tableau formula = DATE(Date-Time Edited in SF)=15/11/17
I am assuming that Tableau Online is converting the Time in the Salesforce Field back to UTC, is that correct?
Other than DATEADD is there an alternate solution to this issue?