Hello -
I am connecting to a Teradata database through a Presto driver and when I go to create a custom calculation for my fiscal month I am getting a conflicting expression types expected datetime found date error message.
The date field I am using in the calculation is a date field. I am casting it as a date in my query and the field type in Prep shows it as a date.
I use this calculation with other databases without an issue. Has anyone run into this with Presto and if you have how did you resolve it?
Thanks!
Kate
2 answers
in case anyone else runs into this casting all of my dates as timestamps seems to have solved it.
