PC2022Helper III1 year agoSolvedAnd, DateDiff I need to determine which Expiration Date is 30 days out and highlight it. I was trying to write the formula below and then use "1", "0" in the conditional formatting. My formula doesn't work. Can an...Show MoreFreemanZ to PC20221 year agohi PC2022 , depending on your business logic, you need to change it to: ApproachingDate = IF ( NOT ISBLANK (( crcc5_permitcoordination[Expiration Date] )) && DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) >=30, "red" )
FreemanZ to PC20221 year agohi PC2022 , depending on your business logic, you need to change it to: ApproachingDate = IF ( NOT ISBLANK (( crcc5_permitcoordination[Expiration Date] )) && DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) >=30, "red" )
FreemanZ to PC20221 year agohi PC2022 , depending on your business logic, you need to change it to: ApproachingDate = IF ( NOT ISBLANK (( crcc5_permitcoordination[Expiration Date] )) && DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) >=30, "red" )
FreemanZSuper User1 year agohi PC2022 , depending on your business logic, you need to change it to: ApproachingDate = IF ( NOT ISBLANK (( crcc5_permitcoordination[Expiration Date] )) && DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) >=30, "red" )
Related contentDATEDIFF DAXDatediff between latest date and todays dateDATEDIFF - HOURS AND MINUTESDATEDIFF and IFDATEDIFF Working Days
