Date issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2105263%22%20slang%3D%22en-US%22%3EDate%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2105263%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20issue%20with%20the%20date%20format%20in%20a%20list%20where%20the%20date%20comes%20as%20additional%20information%20from%20a%20lookup%20column%20in%20another%20list.%3CBR%20%2F%3EI%20therefore%20do%20not%20have%20a%20general%20date%20issue%2C%20all%20other%20dates%20are%20correct.%3CBR%20%2F%3EI%20have%20a%20normal%20date%20field%20in%20my%20lookup%20list%20and%20the%20date%20appears%20here%20correctly.%20When%20the%20date%20appears%20via%20a%20lookup%20column%20in%20the%20second%20list%2C%20it%20is%20displayed%20correctly%20in%20SharePoint%2C%20but%20I%20can%20not%20select%20it%20in%20the%20Gantt%20view%2C%20and%20in%20the%20export%20it%20appears%20as%20follows%202020-02-18%2000%3A00%3A00%2C%20which%20is%20not%20a%20usable%20format.%3CBR%20%2F%3ECan%20anyone%20help%20with%20a%20solution%3F%3CBR%20%2F%3EVH%3CBR%20%2F%3EJenrii%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2105263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have an issue with the date format in a list where the date comes as additional information from a lookup column in another list.
I therefore do not have a general date issue, all other dates are correct.
I have a normal date field in my lookup list and the date appears here correctly. When the date appears via a lookup column in the second list, it is displayed correctly in SharePoint, but I can not select it in the Gantt view, and in the export it appears as follows 2020-02-18 00:00:00, which is not a usable format.
Can anyone help with a solution?
VH
Jenrii

0 Replies