Bad date format?

Question

Bad date format?

pmcculey opened this issue 5 years ago · 7 comments

I'm using this in redmine v4.1.0. I'm finding that the date produced is transposing month and day & time is not formatted per the redmine settings. If I set a custom field using the Date Time and then use that custom field when creating an issue, then if I select say May 2nd 2020 at 22:00 in the date time field, when I later view the issue, the date is showing as 05/02/2020. The redmine global date settings (administration/Settings/Display) are for the users language. For me (English (british) language setting) I'd expect a date of the format 02/05/2020. In truth though even if I select a format of yyyy-mm-dd and 24 hour time format in the settings, the displayed format when I view the issue is still 05/02/2020 with time as 10:00 PM. If I edit that issue, date & time are as I entered them in the custom field.

Redmine start dates and due dates are fine.

Seems like a locale issue, but I'm not seeing how to sort it out.

Answer 1 · 2020-01-29T23:03:25.000Z

Hi, I just tested with V4.1 and I don't have the issue.

I tested with Date and Time format Based on user's language set in the Redmine Settings
With French and English British set in the user profile.
I tested also with English date format in Redmine Settings
Also, with French and English British set in the user profile.

Does the issue happens by selecting date through the calendar ?
If you type the date time, you have to use the international format anyway, unlike the standard date fields where editing the date is structured depending on the language that was chosen.

This constraint comes partly from the external JS library used : XDSoft for JS DateTime Picker

Answer 2 · 2020-01-29T23:33:31.000Z

Thanks so much for the reply. I guess my next move is to try it in a fresh install then. I really want this to replace the start/due dates in Redmine. When I enter dated in the date time custom field, I want those date times to be the issue start/due times. Is that possible assuming I solve the format issue? Thanks again for your help. Joe P. S. I'm using the Bitami redmine install.

…

On Wed 29 Jan 2020, 23:03 Utopism, ***@***.***> wrote: Hi, I just tested with V4.1 and I don't have the issue. - I tested with Date and Time format Based on user's language set in the Redmine Settings With French and English British set in the user profile. - I tested also with English date format in Redmine Settings Also, with French and English British set in the user profile. Does the issue happens by selecting date through the calendar ? If you type the date time, you have to use the *international format* anyway, unlike the standard date fields where editing the date is structured depending on the language that was chosen. This constraint comes partly from the external JS library used : *XDSoft for JS DateTime Picker* Time format — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3?email_source=notifications&email_token=AC5WS74METHQFY5AMAU7ZJLRAIDL3A5CNFSM4KNMHWF2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKJCOOA#issuecomment-580003640>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AC5WS767HH4OXGM3HP4NWGDRAIDL3ANCNFSM4KNMHWFQ> .

Answer 3 · 2020-01-29T23:39:44.000Z

When I enter dated in the date time custom field, I want those date times to be the issue start/due times. Is that possible assuming I solve the format issue ?

It depends if you want a full integration (Gantt, Calendar, Issue precedes relations, etc.)

Perhaps you should try this plugin : https://github.com/nanego/redmine_datetime_custom_field
That goes more in the direction you want.

Answer 4 · 2020-01-30T00:01:02.000Z

I'll try that as well, thanks for the info. Joe

…

On Wed, 29 Jan 2020 at 23:39, Utopism ***@***.***> wrote: When I enter dated in the date time custom field, I want those date times to be the issue start/due times. Is that possible assuming I solve the format issue ? It depends if you want a full integration (Gantt, Calendar, Issue precedes relations, etc.) Perhaps you should try this plugin : https://github.com/nanego/redmine_datetime_custom_field That goes more in the direction you want. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3?email_source=notifications&email_token=AC5WS7ZWTGZJGYJ5B6XP5XTRAIHUBA5CNFSM4KNMHWF2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEKJFJEY#issuecomment-580015251>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AC5WS7Z472ZFUM6TAS7KZZTRAIHUBANCNFSM4KNMHWFQ> .

Answer 5 · 2020-02-10T22:29:57.000Z

Hi @pmcculey, did you had any time to have the plugin working successfully ?

Answer 6 · 2020-02-11T08:04:25.000Z

Unfortunately so far I have not managed to get the other one you recommended working as I want either. It may me a misunderstanding on my part how to use it or maybe its just not possible. I needed the date and time as I was going to use this both as a scheduling tool for a radio telescope and as a general observatory management system. Initially it looked ideal. I'll keep playing with it as time allows. Many thanks, Joe

…

On Mon, 10 Feb 2020 at 22:29, Utopism ***@***.***> wrote: Hi @pmcculey <https://github.com/pmcculey>, did you had any time to have the plugin working successfully ? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#3?email_source=notifications&email_token=AC5WS74WDK7E6GWKNF5MVNLRCHIONA5CNFSM4KNMHWF2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOELKRJ4Q#issuecomment-584389874>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AC5WS75SOH654T6F7LJJ7EDRCHIONANCNFSM4KNMHWFQ> .

Answer 7 · 2020-06-11T20:48:30.000Z

Hi V1.0.3 fixes issue with Date not in the user language format.