Handlebars in SQL

Avatar
Ben Girling
Updated
Engaged
Celigo University Level 1: Skilled

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

Comments

4 comments
Date Votes
  • Avatar
    Kathyana Queeman
    Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hi Ben Girling, 

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

    0
  • Avatar
    Tyler Lamparter
    Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

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

    0
  • Avatar
    Megan Callaghan
    Engaged
    Awesome Follow-up

    I'm having this issue too but need handlebars.

    0
  • Avatar
    Tyler Lamparter
    (Edited )
    Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    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.

 

Didn't find what you were looking for?

New post