Re: [libreoffice-users] text to date

2023-10-02 Thread Michael D. Setzer II
From:James Subject:[libreoffice-users] text to date > The shortform of a day (eg. Sun) is not recognized as a date but the > fullname (eg. Sunday) is. > > Sun, Jan 1, 2024 isn't a date > Sunday, Jan 1, 2024 is a date. > > Does anyone know how to converttext in the f

Re: [libreoffice-users] text to date

2023-10-01 Thread Tim Lloyd
This is calc? Are the commas important. I tried with your string and I agree it doesn't recognise that format. I removed the commas and it was converted to 01/01/2024 On 2/10/23 15:22, James wrote: Sun, Jan 1, 2024 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] text to date

2023-10-01 Thread James
The shortform of a day (eg. Sun) is not recognized as a date but the fullname (eg. Sunday) is. Sun, Jan 1, 2024 isn't a date Sunday, Jan 1, 2024 is a date. Does anyone know how to converttext in the format NN, MMM D, to a date? -- To unsubscribe e-mail to: