If (DateTime)
Example
We have a Customers dataset which we will use to evaluate and transform the ShipDate field.
In this example we will use the Expression object to define the condition, and a Variables object to define thenValue and elseValue.
Where,
Condition: ShipDate = “1”
thenValue = 1/2/2022
elseValue = 5/7/2023
In the output, you can see that DateTime values, 1/2/2022 and 5/7/2023, have been returned depending on whether the ShipDate field condition was met.