Adding Date to If Statement

Platform discussions Special workflows & use cases
1

Hey, i’m trying to add an if statement for a formula so it wont affect previous items.

the formula:

IF({TPA WFS} = ‘90 Degrees(EBSO)’, “.15”, IF({SI PRE-SAVINGS} > 2500 ,“.15”,“.25”))

I would like it to be If the FILL DATE is 10-9-2023 or before to be

IF({TPA WFS} = ‘90 Degrees(EBSO)’, “.15”, IF({SI PRE-SAVINGS} > 1999.99 ,“.15”,“.25”))

So far i’m not having any luck changing this.

2

@JCorrell Any adivce?

3

IF(
{FILL DATE} < FORMAT_DATE(DATE(2023, 10, 10), “YYYY-MM-DDTHH:mm:ss”),
IF({TPA WFS} = ‘90 Degrees(EBSO)’, “.15”, IF({SI PRE-SAVINGS} > 1999.99 ,“.15”,“.25”)),
IF({TPA WFS} = ‘90 Degrees(EBSO)’, “.15”, IF({SI PRE-SAVINGS} > 2500 ,“.15”,“.25”))
)

This might work actually…

4

@Mrjoelbaker

Did you get it working?