Can't apply date functions to a date column

I get “Unknown method” when applying any date-related snaplogic function to a column that is a local-date-time.

I tried this with two separate clients with different schemas and data types, still same issue. Is this a bug?

There is a DateTime type and a LocalDateTime type. Here is an example that shows the difference and one way to convert from the LocalDateTime to a DateTime type.


date-example_2021_05_10.slp (7.9 KB)

Here are how we convert some common database types into the Expression Language types in case it’s helpful for you.