Handlebars in SQL

Ben Girling

• May 15, 2023 15:43
• Edited

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

0

• 

  Kathyana Rule Community moderator Technical Writer

  • May 16, 2023 15:56

  

  

  Hi Ben Girling, 

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

  0
• 

  Tyler Lamparter Principal Product Manager

  • May 24, 2023 18:14

  

  

  

  

  

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

  

  

  0
• 

  Megan Callaghan

  • July 25, 2023 21:17

  

  

  I'm having this issue too but need handlebars.

  0
• 

  Tyler Lamparter Principal Product Manager

  • July 27, 2023 12:37
  • Edited

  

  

  

  

  

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

  0

Please sign in to leave a comment.