Date Match Formula Error
Date match formula errors when I run the report.
CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."PER_ASG_DF_CNTNS_SRVC_T_" THEN 'Match' ELSE 'Does Not Match' END
I need this to work as its an exception report for the team. Can anyone please assist with this?
I have added a formula to flag matched and unmatched Statutory Absence Service Date and Continuous Service Date.
Both date fields come from different subject areas and have been joined by measures from each subject area as below: