Bug 167387 - Writer changes date format when saving
Summary: Writer changes date format when saving
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
25.2.4.3 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Fields-Dialog
  Show dependency treegraph
 
Reported: 2025-07-05 04:11 UTC by Elmar
Modified: 2025-09-06 13:16 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
doc display incrorretc date format (22.96 KB, application/vnd.oasis.opendocument.text-template)
2025-07-05 04:21 UTC, Elmar
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Elmar 2025-07-05 04:11:56 UTC
Description:
The ISO date format is yyyy-mm-dd
It is what I prefer as well, because it makes sorting more intuitive and not as ambiguous as the US format mm/dd/yyyy (e.g. what is 12/09/2025?)
It appears that the date field inserted is changed to US format 

Steps to Reproduce:
1.insert docinformation:modified field into document
2.select ymd format
3.save document
open document

Actual Results:
date has changed to mdy format

Expected Results:
format set should be persistent


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: TextDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bc58a54d513702bc07906627dce073f05d7978fd
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-ZA (en_ZA.UTF-8); UI: en-US
Calc: threaded
Comment 1 Elmar 2025-07-05 04:21:39 UTC
Created attachment 201662 [details]
doc display incrorretc date format

It appears that it is not SAVED in the wrong format, but when it OPENS the document it changes the format.
This is so when I open doc in version 24.2.7.2 as well.
but not in older versions (cannot recall how far back)

HOWEVER: when I open the doc with Abiword, the format is correct: ymd
Comment 2 Dieter 2025-07-05 09:24:25 UTC
Can't confirm with

Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 12; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded

Steps:
1. Open attachment 201662 [details]

Actual and expected result:
In footer field with yyyy-mm-dd format

Same with

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bfa28a257ae621747dddbb61f228705cf46079b8
CPU threads: 12; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: CL threaded

Perhaps only a Linux-problem?
Field name is DocInformation:3CreatedDate. Have you checked settings in document properties (but I must admit, that I'm not so familiar with that topic)
Comment 3 Mateusz Wlazłowski 2025-07-05 11:06:23 UTC
Confirm with additional step: 

Set the local setting to "Afrikaans (South Africa)" in "Options - Languages and locals - General"


Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: af-ZA (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded