# Custom Report: Custom Field Date format is not same **URL:** \ **Category:** Uncategorized\ **Created:** [September 17, 2019, 10:29am UTC](https://forum.manager.io/t/custom-report-custom-field-date-format-is-not-same/24303 "2019-09-17T10:29:30Z")\ **Posts on this page:** 1\ **Showing post:** 8
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [September 17, 2019, 10:50pm UTC](https://forum.manager.io/t/custom-report-custom-field-date-format-is-not-same/24303/8 "2019-09-17T22:50:57Z")
> [@Davide](#): > > this is not a solution but just a workaround… Agree Until a better solutions is available, for those who have or can install LibreOffice > [@Bank statement import \*csv wrong value in ver.19.7.34](https://forum.manager.io/t/bank-statement-import-csv-wrong-value-in-ver-19-7-34/23427/16): > > For a one off solution you can > > 1. Open the bank statement in a spreadsheet program. This may involve customising the setting in the import graphical module to correctly parse you delimiter separated text file. [LibreOffice](https://www.libreoffice.org/) delimiter separated values importer enables specification of date format and language / number setting. > 2. Format it as required. Within the spreadsheet the [NUMBERVALUE()](https://help.libreoffice.org/6.2/en-GB/text/scalc/01/func_numbervalue.html?System=WIN&DbPAR=CALC&HID=SC_HID_FUNC_NUMBERVALUE#bm_id3163820) function enables converting text to numbers in a language independent fashion. Similarly the [TEXT()](https://help.libreoffice.org/6.2/en-GB/text/scalc/01/04060110.html?System=WIN&DbPAR=CALC&HID=SC_HID_FUNC_TEXT#bm_id3156426) converts a number to a language specific text string such as the format “#.##”. > 3. Export it as basic coma separated values (no commas in the numbers and “.” as a decimal separator). --- _[View the full topic](https://forum.manager.io/t/custom-report-custom-field-date-format-is-not-same/24303)._