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.

© Copyright 2023, Astera Software