I need to add a filter using a between dates. But the table I’m using stores dates in type numeric. So apparantly Metabase can not identify this as a Date.
I tried to do this in the select:
- CONVERT(date, CAST(CE061_DT_PGTO AS varchar), 112) AS DATA,
But when I tried to add the filter it says that there is no valid fields.
This msg appeard somewhere else but I don’t remember where: Operand type clash: datetime2 is incompatible with numeric
Someone else have deal with this situation?