Date Format Error
I am receiving the below error, and I am not sure if I can change the csv import.
it is looking for the xx-xx-xxxx format.
{"errorCode":1042,"message":"The value for cell in column 7629496376944516, 05/31/2023, did not conform to the strict requirements for type DATE.","refId":"o5mv4g","detail":{"index":0}}
-
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 -
I am trying to import a csv into SmartSheet.
0 -
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 -
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 -
I need to be able to send that last value at mm-dd-yyy because it will not accept mm/dd/yyy
0 -
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 -
That worked!!!! Thank you so much!
0
Please sign in to leave a comment.
Comments
7 comments