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

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:
    
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?

2 Likes

I have the same problem

Please use postgres for production for selfhosting.

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.