Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team
I'm working on the below query and cannot get the null function to produce the required result
Permit Status =
IF(required[ExpiryDate] <= TODAY(), "Expired",
IF(required[ExpiryDate >= TODAY(), "Current",
IF(required[ExpiryDate=null, "Not Defined",)))
Can somebody please help with this??
Cheers
z
Solved! Go to Solution.
Permit Status =
IF(ISBLANK(required[ExpiryDate]), "Not Defined",
IF(required[ExpiryDate] <= TODAY(), "Expired",
"Current"))
Permit Status =
IF(ISBLANK(required[ExpiryDate]), "Not Defined",
IF(required[ExpiryDate] <= TODAY(), "Expired",
"Current"))
Thanking you 🙂