I am getting the week number from a short date.
week_number: DatePart(“ww”;[close_date];2)
The result is in number format, e.g. 29.
However, in another query, I cannot filter the result because an error occurs: Data type mismatch in criteria expression.
I can’t find the reason for the error. Help please!