jbo
February 21, 2025, 7:56pm
1
Hello,
I’m starting my journey with nocodb.
My config : nocodb 0.260.2
with self-hosting.
I notice the formatting formula results for date and numeric aren’t available (test on opera):
I check the docs :
I know there is an update since 0.260.2 but i didn’t see any mention about that in the changes.
Any idea to get this feature back?
Thank you for the help.
dstala
February 22, 2025, 4:02am
3
for a formula resulting in date, i do see formatting options available as desired. please try out in latest version & let us know if you still see any issue with that.
also share formula computation with associated field types for the variables used to help us better.
jbo
February 22, 2025, 3:38pm
4
Hello @dstala ,
Thank you for your answer.
I will test again after the update to the latest version.
The formula is :
CONCAT({Annee}, "-", {Mois}, "-", {Jour})
Annee : string
Mois : string
Jour : string
Maybe it just simple as i can’t convert string to date…
It’s yet a work-around because of a bug with the date at import:
opened 08:44PM - 21 Feb 25 UTC
### Please confirm that the bug report does ***not*** already exist
- [x] I con… firm there is no existing issue for this bug.
### Steps to reproduce
When importing dates from an Excel file using the DD-MM-YYYY format, some dates are incorrectly interpreted with month and day inverted (MM-DD-YYYY), despite the format being explicitly set to DD-MM-YYYY in the table configuration.
1. Create an Excel file with a date column containing the following dates (DD-MM-YYYY format):
15-01-2025
13-01-2025
09-01-2025
02-01-2025
31-12-2024
10-12-2024
2. In the application table settings:
- Add a new date field
- Set its format to DD-MM-YYYY
3. Import the Excel file:
- Upload the file
- Map the Excel date column to the configured date field
Actual behavior:
Some dates are incorrectly imported with day and month inverted:
15-01-2025 -> 15-01-2025 (correct)
13-01-2025 -> 13-01-2025 (correct)
09-01-2025 -> 01-09-2025 (incorrect - inverted)
02-01-2025 -> 01-02-2025 (incorrect - inverted)
31-12-2024 -> 31-12-2024 (correct)
10-12-2024 -> 12-10-2025 (incorrect - inverted)
Pattern observed:
The inversion seems to occur when the day number is less than 12, suggesting the system might be falling back to US date format (MM-DD-YYYY) for these specific cases.
### Desired Behavior
Expected behavior:
All dates should be imported respecting the DD-MM-YYYY format.
Result of the import:
15-01-2025
13-01-2025
09-01-2025
02-01-2025
31-12-2024
10-12-2024
### Project Details
Node: **v22.13.0**
Arch: **x64**
Platform: **linux**
Docker: **true**
RootDB: **pg**
PackageVersion: **0.260.2**
### Attachments

I notice it is in good hands yet!
jbo
February 24, 2025, 8:18pm
5
I update to 0.262.0 and it doesn’t change anything:
Example in video → 1.32 MB file on MEGA
Ameesha
February 27, 2025, 4:57am
6
The bug has been fixed, and the changes are now reflected in version 0.262.1 . Please upgrade to the latest version and let us know if you face any further issues.