Hi,
Im having some troubles with Date formatting going into Oracle Netsuite from a SQL server export.
I decided perhaps the best way to try and format the date was to use the {{DateFormat}} handlebar. However, it doesnt seem to see the value.
I've added this into my select statement ...
{{dateFormat "DD/MM/YYYY" ProductionDate "DD-MM-YYYY"}}
However, I get an error saying "Message: handlebars Helper {{dateFormat}} expects date argument when you have i/p date format".
If I put this together in the developer playground it works fine. Do I need add something to the ProductionDate column name to signify that it is coming from the data?
Many Thanks