# Date Format Error

**URL:** <https://connective.celigo.com/t/date-format-error/449>\
**Category:** Integrator.io\
**Tags:** csv, error-handling, import\
**Created:** [May 22, 2023, 5:26pm UTC](https://connective.celigo.com/t/date-format-error/449 "2023-05-22T17:26:48Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonretherford](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jasonretherford](https://connective.celigo.com/u/jasonretherford)\
**Post date:** [May 22, 2023, 5:26pm UTC](https://connective.celigo.com/t/date-format-error/449/1 "2023-05-22T17:26:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![kathyanaqueeman](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kathyanaqueeman/32/9122_2.png) [@kathyanaqueeman](https://connective.celigo.com/u/kathyanaqueeman)\
**Post date:** [May 22, 2023, 6:13pm UTC](https://connective.celigo.com/t/date-format-error/449/2 "2023-05-22T18:13:56Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![jasonretherford](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jasonretherford](https://connective.celigo.com/u/jasonretherford)\
**Post date:** [May 22, 2023, 6:17pm UTC](https://connective.celigo.com/t/date-format-error/449/3 "2023-05-22T18:17:30Z")

</div>

I am trying to import a csv into SmartSheet.

 ![5301043caa20740200000001-08ac750f78664c16872540be31f33810.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/978dd2fe93ee0db851715af204c495294786c56d.png)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 22, 2023, 7:03pm UTC](https://connective.celigo.com/t/date-format-error/449/4 "2023-05-22T19:03:07Z")

</div>

@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](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](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/953aa8c0b1468bc47cb8dc031aab3b6078e66187.png)

---

<div class="post-metadata">

**Author:** ![jasonretherford](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jasonretherford](https://connective.celigo.com/u/jasonretherford)\
**Post date:** [May 22, 2023, 7:16pm UTC](https://connective.celigo.com/t/date-format-error/449/5 "2023-05-22T19:16:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jasonretherford](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jasonretherford](https://connective.celigo.com/u/jasonretherford)\
**Post date:** [May 22, 2023, 7:17pm UTC](https://connective.celigo.com/t/date-format-error/449/6 "2023-05-22T19:17:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 22, 2023, 7:39pm UTC](https://connective.celigo.com/t/date-format-error/449/7 "2023-05-22T19:39:45Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jasonretherford](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jasonretherford](https://connective.celigo.com/u/jasonretherford)\
**Post date:** [May 23, 2023, 12:35pm UTC](https://connective.celigo.com/t/date-format-error/449/8 "2023-05-23T12:35:36Z")

</div>

That worked!!!! Thank you so much!