# Formatting Formula Results - No Date format, no numeric format **URL:** \ **Category:** Formulas\ **Created:** [February 21, 2025, 7:56pm UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676 "2025-02-21T19:56:36Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)\ **Post date:** [February 21, 2025, 7:56pm UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/1 "2025-02-21T19:56:37Z")
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): ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/ca41ccc4fa902d711a54381805ac223292c17c8d.png) I check the docs : > **[Formatting Formula Results | NocoDB](https://docs.nocodb.com/fields/field-types/formula/formula-result-formatting/#date-formats)** > > This article explains how to format the output of formulas in NocoDB, covering various formatting options based on the result type. 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. ---
**Author:** ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)\ **Post date:** [February 21, 2025, 7:58pm UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/2 "2025-02-21T19:58:58Z")
![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/bf4f174638f8dfd88fa7d76631a5ab1711eb8479.png) ---
**Author:** ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)\ **Post date:** [February 22, 2025, 4:02am UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/3 "2025-02-22T04:02:42Z")
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. ![Screenshot 2025-02-22 at 9.30.49 AM](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/8f43ac87b42a125c241e894b8d300571f88065b8.png) ---
**Author:** ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)\ **Post date:** [February 22, 2025, 3:38pm UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/4 "2025-02-22T15:38:02Z")
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: > > > \### 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 > > !\[Image\](https://github.com/user-attachments/assets/0e06e4dc-4fc3-438e-9b3c-15c62cdbd7bc) I notice it is in good hands yet! ---
**Author:** ![jbo](https://yyz1.discourse-cdn.com/flex011/user_avatar/community.nocodb.com/jbo/32/630_2.png) [@jbo](https://community.nocodb.com/u/jbo)\ **Post date:** [February 24, 2025, 8:18pm UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/5 "2025-02-24T20:18:13Z")
I update to 0.262.0 and it doesn’t change anything: Example in video → [1.32 MB file on MEGA](https://mega.nz/file/XF0QTCrK#Fiqq1tHod9wCv6SPMLnM3T8d0M0fMSRStVbQtrUQ6iQ) ---
**Author:** ![Ameesha](https://avatars.discourse-cdn.com/v4/letter/a/3be4f8/32.png) [@Ameesha](https://community.nocodb.com/u/Ameesha)\ **Post date:** [February 27, 2025, 4:57am UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/6 "2025-02-27T04:57:28Z")
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. ---
**Author:** ![cfischer69](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@cfischer69](https://community.nocodb.com/u/cfischer69)\ **Post date:** [April 7, 2025, 8:23pm UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/7 "2025-04-07T20:23:41Z")
Is this not available in cloud? ---
**Author:** ![Ameesha](https://avatars.discourse-cdn.com/v4/letter/a/3be4f8/32.png) [@Ameesha](https://community.nocodb.com/u/Ameesha)\ **Post date:** [April 8, 2025, 4:49am UTC](https://community.nocodb.com/t/formatting-formula-results-no-date-format-no-numeric-format/1676/8 "2025-04-08T04:49:36Z")
Yes, the [format bug](https://github.com/nocodb/nocodb/issues/10584) has been fixed and the changes are available in both the OSS and Cloud versions. Let us know if you’re still facing any issues!