Troubleshooting Lookup Column Errors in Data Tables

Hi team, I get the below error when trying to create a new column from a lookup in another table: "Failed to parse formula with error: {"offset":14,"token":{"type":"RAW_IDENT","value":"in","text":"in","offset":66,"lineBreaks":0,"line":1,"col":67}}" It's a date, and I've tried formatting in different ways but still get the error - which is weird because I can pull other dates in the same lookup column without issue. Here's the table: https://app.clay.com/workspaces/223473/workbooks/wb_0sx0p6e5Fy2d2hvTaU2/tables/t_0sxfk0lX8nd62GcY5HG/views/gv_0sxfk0mHiAdjkNiEbgR I'm using the green highlighted "Lookup Site" column to try and extract the "Final - Date Machine Declared "in service" field.