Date Format Error

Comments

7 comments

  • Kathyana Rule Community moderator Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    Hi Jason Retherford

    I have moved this post to the Troubleshoot custom flows section for more visibility. It might also be helpful if you could include more information about your flow including any relevant images. Thanks! 

    0
  • Jason Retherford
    Engaged

    I am trying to import a csv into SmartSheet. 

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

    Jason Retherford did you try using handlebar expressions to convert the date into a format that Smartsheets accepts? See docs here: https://docs.celigo.com/hc/en-us/articles/360039326071-Handlebars-helper-reference

     

    Also, here is an expression I made to convert:

    {{dateFormat "MM-DD-YYYY" dateField "MM/DD/YYYY"}}

    0
  • Jason Retherford
    Engaged

    This is what I have.. please excuse me as I know enough to be dangerous!! not a programmer at all!!

     

    [
    {
    "toTop":true,
    "cells":[
    {
    "columnId": "4814746609837956",
    "value":"{{record.[Project#]}}"
    },
    {
    "columnId": "2562946796152708",
    "value":"{{record.[%Complete]}}"
    },
    {
    "columnId": "7066546423523204",
    "value":"{{record.Name}}"
    },
    {
    "columnId": "1437046889310084",
    "value":"{{record.[Budget hours]}}"
    },
    {
    "columnId": "5940646516680580",
    "value":"{{record.[Budget - Worked Gap hours]}}"
    },
    {
    "columnId": "3688846702995332",
    "value":"{{record.[Planned hours]}}"
    },
    {
    "columnId": "8192446330365828",
    "value":"{{record.[Approved hours]}}"
    },
    {
    "columnId": "874096935888772",
    "value":"{{record.[Worked hours]}}"
    },
    {
    "columnId": "5377696563259268",
    "value":"{{record.[Project Type]}}"
    },
    {
    "columnId": "3125896749574020",
    "value":"{{record.[Project stage]}}"
    },
    {
    "columnId": "7629496376944516",
    "value":"{{record.[End Date]}}"
    }
    ]
    }
    ]

    0
  • Jason Retherford
    Engaged

    I need to be able to send that last value at mm-dd-yyy because it will not accept mm/dd/yyy

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

    Jason Retherford if you want to be more dangerous, there are courses in Celigo University to learn more about handlebar expressions. You can find the university on the left menu and then you can find them by searching for "handlebar" under content learning. 

     

    That being said, you would just need to put 

    "value":"{{dateFormat "MM-DD-YYYY" record.[End Date] "MM/DD/YYYY"}}"
    0
  • Jason Retherford
    Engaged

    That worked!!!!  Thank you so much!

    0

Please sign in to leave a comment.