Hi there,
I dont understand the difference between 2 formulas :
IF(
AND(
{Startdatum Leverancier (rol repowered)} != BLANK(),
{Einddatum leverancier (rol repowered)} = BLANK()
),
"OT",
IF(
AND(
{Startdatum Leverancier (rol repowered)} = BLANK(),
{Einddatum leverancier (rol repowered)} = BLANK()
),
"",
"BT"
)
)
This formula does NOT work as intended and ALWAYS shows OT regardless of the 2 fields content (empty or filled). I need to add that these fields are date fields.
IF(
{Startdatum Leverancier (rol repowered)} = BLANK(),
"",
IF(
{Einddatum leverancier (rol repowered)} = BLANK(),
"OT",
"BT"
)
)
This one DOES work as intended. Although I fixed the issue my curiousity is getting the better of me what I did wrong in the first bit of code. Anybody ideas?