I’m new to snapLogic and can’t figure out how to format my date/time column in an Excel spreadsheet. I have a SQL Server Execute pipeline that emails output in an Excel spreadsheet to my user. The column currently looks like this (I couldn’t cut/paste for some reason):
I thought by selecting ‘translate date and time types’ in my Excel Formatter snap would have done the trick but apparently not. What am I missing?