Forum Discussion

Mark's avatar
Mark
New Contributor II
4 years ago

Excel Formatter - need date datatype with this format MM/DD/YYYY

Im using Excel Formatter. I am selecting from Oracle. I need the column in excel to be date datatype, but have this format MM/DD/YYYY with no time on the end. I can get the date into that format ...
excel
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
4 years ago

@Mark

Try to select the date as string from Oracle, and then parse it in SnapLogic as date before Excel Formatter. In Excel Formatter Snap check the “Translate date and time types”.

I am also attaching sample pipeline:

Comm_2022_03_09.slp (7.5 KB)

Hope this will helps.

BR,
Spiro Taleski