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?
Here is a link which might help..
NOW() Function Returns UTC Time | Tableau Software
And here is a vote.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...