This content has been marked as final. Show 2 replies
1 of 1 people found this helpful
if DATE(Today())>=[Booking Date] and
DATE(Today())<=[PSR_Summary (DATAMART)].[Completion Date]
then "Active" ELSE "Not Active" END
This should work having [Project_ID] in lines
Thanks Luciano. That helped so much!