Source to Target Expressions

I have a Source to Target (SharePoint Rest Action to Snowflake) river that is pulling in an excel file. There is a date field that is coming in as an integer and I need to convert it to a date or date time. I’ve tried every type of date conversion syntax and nothing is working. I think I’m missing something. I’ve read through the documentation, but still nothing is working.

Hi Airwin - Our support team would be happy to assist with your question! Can you open up a support ticket within the console by navigating on the left-hand side to Help → Contact Support? Thanks!