Formatting date/time in Excel formatter

[Bmorechick27]

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):
2018-09-17T14:42:22.480

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?

[kristinajosifov]

Hi,
Try this in SQL Server Execute snap for date output:
SELECT CONVERT(varchar(10),(select replace(‘2018-09-17T14:42:22.480’,‘T’,’ ‘)), 105)
or date and time output:
SELECT CONVERT(varchar(19),(select replace(‘2018-09-17T14:42:22.480’,‘T’,’ ')), 105)
Regards.