# Baserow date formate on n8n

**URL:** https://community.baserow.io/t/baserow-date-formate-on-n8n/3641
**Category:** Technical Help
**Tags:** n8n
**Created:** [October 25, 2023, 9:20am UTC](https://community.baserow.io/t/baserow-date-formate-on-n8n/3641 "2023-10-25T09:20:49Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![noe.camatte](https://community.baserow.io/letter_avatar_proxy/v4/letter/n/e9a140/32.png) [@noe.camatte](https://community.baserow.io/u/noe.camatte)
#### Post date: [October 25, 2023, 9:20am UTC](https://community.baserow.io/t/baserow-date-formate-on-n8n/3641/1 "2023-10-25T09:20:50Z")

</div>

I’ve formatted a date on n8n to send to baserow but I can’t get it to work.  
The import works when I try to send all fields other than this one.  
So I guess that’s where the problem lies.  
Does anyone know how I should format my date from n8n so that it is accepted on baserow?  
Thanks 🙏  
Also, if you have any documentation on all the formats that need to be taken into account for the different types of fields, I’d be interested.

#### Provide screenshots or include share links showing:

---

<div class="post-metadata">

### Author: ![frederikdc](https://community.baserow.io/user_avatar/community.baserow.io/frederikdc/32/2086_2.png) [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [October 25, 2023, 12:27pm UTC](https://community.baserow.io/t/baserow-date-formate-on-n8n/3641/2 "2023-10-25T12:27:16Z")

</div>

Hi,

Baserow uses the ISO date format which is YYYY-MM-DD. You can use the JavaScript function [toISOString](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toISOString)() to get the date in the correct format.

If you only need the date without time or other information you can also use  
`{ $node["Name of the node"].json["start_date"].slice(0,10)}}`

This takes the first 10 characters from a date which results in YYYY-MM-DD

---

<div class="post-metadata">

### Author: ![noe.camatte](https://community.baserow.io/letter_avatar_proxy/v4/letter/n/e9a140/32.png) [@noe.camatte](https://community.baserow.io/u/noe.camatte)
#### Post date: [November 1, 2023, 10:04am UTC](https://community.baserow.io/t/baserow-date-formate-on-n8n/3641/3 "2023-11-01T10:04:15Z")

</div>

Thanks a lot for your help, I will try with this 🙏