# Insert date into MS Access DB

**URL:** <https://community.ofelia.com/t/insert-date-into-ms-access-db/5638>\
**Category:** Q&A\
**Created:** [9 February 2015 16:42 UTC](https://community.ofelia.com/t/insert-date-into-ms-access-db/5638 "2015-02-09T16:42:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kwatkar](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kwatkar](https://community.ofelia.com/u/kwatkar)\
**Post date:** [9 February 2015 16:42 UTC](https://community.ofelia.com/t/insert-date-into-ms-access-db/5638/1 "2015-02-09T16:42:18Z")

</div>

Hi,

I am new to Bonita Soft and using BonitaSoft 5.8 .  
I am creating a web form to get some user data and store it in MS access DB using a connector.

I am able to save the text or numerical type data into database. But I am unable to store a DOB of user (Date/Time type defined in MS access DB) . Below is the query that I am using while configuring the MS access connector.  
INSERT INTO User (firstName, lastName, sex, dob) VALUES (‘${firstName}’, ‘${lastName}’, ‘${sex}’, ‘${dob}’);

I am getting below error for date field:  
SEVERE: Exception caught while executing connector (instance=TestProcess1–1.0–1, process=TestProcess1–1.0, activityId=User\_Input) : org.bonitasoft.connectors.database.access.AccessConnector - Exception : [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Please help me to resolve this issue.

–  
Thanks,  
Kunal

---

<div class="post-metadata">

**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\
**Post date:** [10 February 2015 12:42 UTC](https://community.ofelia.com/t/insert-date-into-ms-access-db/5638/2 "2015-02-10T12:42:41Z")

</div>

Your date format is probably wrong…

Bonita dates are JAVA dates not MS Access dates so

try doing

_INSERT INTO User (firstName, lastName, sex, dob) VALUES (‘${firstName}’, ‘${lastName}’, ‘${sex}’, ‘2015-01-01 10:15’);_

first and if this works, then modify dob to be a string value… and try like above…

regards  
Seán

---

<div class="post-metadata">

**Author:** ![kwatkar](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@kwatkar](https://community.ofelia.com/u/kwatkar)\
**Post date:** [10 February 2015 14:39 UTC](https://community.ofelia.com/t/insert-date-into-ms-access-db/5638/3 "2015-02-10T14:39:25Z")

</div>

Hi Sean,

Thanks for the hint. While testing the connector, I used the string as a date and that was working.  
Now, I am converting my date to string format and then use in SQL statement and its working.

–  
Regards,  
Kunal

---

<div class="post-metadata">

**Author:** ![s.morais.f](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@s.morais.f](https://community.ofelia.com/u/s.morais.f)\
**Post date:** [31 March 2016 18:59 UTC](https://community.ofelia.com/t/insert-date-into-ms-access-db/5638/4 "2016-03-31T18:59:37Z")

</div>

Hi kwatkar,

I saw you could save the text or numerical type data into database and that’s part of what I’m looking for.  
Would you help me?

[http://community.ofelia.com/questions-and-answers/how-can-i-develop-meeting-room-schedule-software-application](http://community.ofelia.com/questions-and-answers/how-can-i-develop-meeting-room-schedule-software-application)

Thank you for considering, Sergio.