trx_week not calculating correctly when the week crosses years
I am having an issue where the days in the 12/31/2023 week cross into 2024. I am summing hours worked for the week, but it only returns half of the hours. I have tried creating a new column to concatenate the year-month using various formulas noted below, but I still get the 'The calculation contained a syntax error'. Is…
