Description
Please confirm that the feature request does not already exist
- I confirm there is no existing issue for this feature request.
Use case
Hello team,
I love your product but there is one major issue : date management.
Almost everywhere in the world we use DD-MM-YYYY (11-02-2025 for example), the problem is when you set format in date column, the format is only visual.
As result, when we update date using the WebUI, the date is still push in MM-DD-YYYY (02-11-2025) format and when we retrieve this data in from the nocodb API we get "02-11-2025" instead of "11-02-2025". It's very painful in the situation of AI Agent in N8N.
My agent sometime need using date in my database but because some of the date are in DD-MM-YYYY (API writen) and other are in MM-DD-YYYY (WebUI updated) it become a mess.
Suggested solution
The patch is pretty easy to do i think :
When user change date from the WebUI, browser request need to send date in the format choose by the user for that column in my case DD-MM-YYYY.
Additional context
This improvement will resolve the only BIG problem i have with nocodb using AI Agent. AI Agent are very powerful but it's very important to maintains consistency in the API result when user may edit date in the WebUI.
Big love on you team ❤️❤️❤️❤️❤️