Hello all,
I've started using Tableau for a few months now, so I'm still a newbie.
My latest blocker is the need to find and replace certain dates in TableauPrep for an excel file that is used as source for Tableau Desktop.
Basically, we have some items that were done last year, and we need to show them as completed at the start of 2023. Shortly to find any date in the respective field that is before 2023-01-01 and change it to 2023-01-01.
I've searched for other similar topics and tried using below calculation:
IF [Actual End Date for System Test] < ⌗2023-01-01#
THEN [Actual End Date for System Test] = ⌗2023-01-01#
END
However, that does't seem to do anything. Your help is really appreciated.
@Alexandru Daniel Mihai you have to write something like below:
IF [Actual End Date for System Test] < ⌗2023-01-01#
THEN ⌗2023-01-01#
ELSE
[Actual End Date for System Test]
END
Check if that helps.
