Date Format Error

Integrator.io
, ,
1

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}}

2

Hi @jasonretherford,

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!

3

I am trying to import a csv into SmartSheet.

5301043caa20740200000001-08ac750f78664c16872540be31f33810.png
5301043caa20740200000001-08ac750f78664c16872540be31f33810.png688×201 4.69 KB

4

@jasonretherford 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"}}

5301043caa20740200000001-35922a6aa77a4ef18671b00d1bd33bfc.png
5301043caa20740200000001-35922a6aa77a4ef18671b00d1bd33bfc.png1352×682 12.4 KB

5

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]}}"
}
]
}
]

6

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

7

@jasonretherford 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"}}"
8

That worked!!!! Thank you so much!