Handlebars in SQL

[bengirling]

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

[kathyanaqueeman]

Hi @bengirling,

I have moved this article to the Troubleshoot custom flows section for more visibility. Thanks!

[tylerlamparter]

@bengirling you probably don't even need handlebars here and can use the built in date formatting function as shown here:

[megancallaghan]

I'm having this issue too but need handlebars.

[tylerlamparter]

@megancallaghan what does your setup look like and what is the error you are getting? Why do you need handlebars?