Solved
Can't apply date functions to a date column
Hello,
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.parse($local.toString()).getFullYear()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.
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438184/Database+Date+Types
