There may be a way to convert the value in some cases within the Workflow, but I think having the logic in an Identity Attribute may perform better and will allow you to audit when those comparisons occur via Access History or Search.
Can you try this operator out? Operators - SailPoint Identity Services
See if the value from Snowflake (or other Sources) qualifies as a Timestamp and then could be used in the Date Comparison.
