Issue with text parsing on date/time populated by automation
I'm having an issue where I have a created date column, then a date column that referenced the created date column and uses text parsing to remove the time. formula below: =DATE(VALUE(20 + MID([Issue Opened Date]@row, 7, 2)), VALUE(LEFT([Issue Opened Date]@row, 2)), VALUE(MID([Issue Opened Date]@row, 4, 2))) This functions…