This is one of three related issues in Data to Text feature, all caused by commit 5b808448dc79e996efa7cb5082145d4e5803daa6, similar to bug 168252 - but all use different code paths, so I split them, to allow test each separately. 1. Register a database using a spreadsheet (ODS) with a date column. 2. Create a text document. 3. View -> Data Sources; expand the ODS datasource, and select its table with the data column. 4. Select a row in the right-hand table in the datasources panel 5. Click [Data to Text] button on the panel's toolbar. 6. Select "Fields" at the top; select the date column name in the Database columns list, and press [ > ] button, then press [OK]. => the inserted field shows +2 days. (Updating fields will fix the shown date after the fix to bug 168252).
https://gerrit.libreoffice.org/c/core/+/190757
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d85d3c3c7ccced49e1f2d3d6c754310a1d44fefe tdf#168348: fix "standard" date in SwInsertDBColAutoPilot::DataToDoc (2) It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/5968a8dea226aa5c23dcad5cccfbd41eac241e6e tdf#168348: fix "standard" date in SwInsertDBColAutoPilot::DataToDoc (2) It will be available in 25.8.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.