# NocoDB v0.262.4 (SQLite3): DATEADD Formula Results in Empty Field - RBU Date + 28 Days

**URL:** <https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749>\
**Category:** Self-Host\
**Created:** [March 25, 2025, 10:18pm UTC](https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749 "2025-03-25T22:18:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![fk\_kpt](https://avatars.discourse-cdn.com/v4/letter/f/e56c9b/32.png) [@fk\_kpt](https://community.nocodb.com/u/fk_kpt)\
**Post date:** [March 25, 2025, 10:18pm UTC](https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749/1 "2025-03-25T22:18:49Z")

</div>

In my self-hosted NocoDB database, I have the following setup:

- 

```
Source field "RBU": Date field in DD/MM/YYYY format

```

- 

```
Target field: Formula field for payment receipt

```

- 

```
Formula used:

```

```auto
DATEADD({RBU}, 28, "day")

```

The result field remains empty although the RBU field contains valid date values (e.g., 01/03/2025).

System Details:

```
NocoDB Version: 0.262.4
Node.js: v18.5.0
Architecture: x64
Platform: Linux
Docker: No (Standalone installation)
Database: SQLite3
Date format: DD/MM/YYYY

```

Expected Behavior:

```
Automatic calculation: RBU date + 28 days
Current result: Empty field

```

Does anyone have a solution for this issue?

---

<div class="post-metadata">

**Author:** ![sgabrielli](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/sgabrielli/32/669_2.png) [@sgabrielli](https://community.nocodb.com/u/sgabrielli)\
**Post date:** [April 16, 2025, 2:20pm UTC](https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749/2 "2025-04-16T14:20:18Z")

</div>

I have the same problem

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [April 16, 2025, 2:29pm UTC](https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749/3 "2025-04-16T14:29:50Z")

</div>

Please use postgres for production for selfhosting.

---

<div class="post-metadata">

**Author:** ![Sabrina](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@Sabrina](https://community.nocodb.com/u/Sabrina)\
**Post date:** [May 2, 2025, 8:34am UTC](https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749/4 "2025-05-02T08:34:14Z")

</div>

Same problem here, also self-hosted, SQLite, with me it’s dd-mm-yyyy format, also tried to make the original field datetime, bit didn’t work either.

---

<div class="post-metadata">

**Author:** ![fendy](https://avatars.discourse-cdn.com/v4/letter/f/3da27b/32.png) [@fendy](https://community.nocodb.com/u/fendy)\
**Post date:** [May 29, 2025, 3:02am UTC](https://community.nocodb.com/t/nocodb-v0-262-4-sqlite3-dateadd-formula-results-in-empty-field-rbu-date-28-days/1749/5 "2025-05-29T03:02:11Z")

</div>

Should be fixed on latest version.