Hi Alex,
I was able to reproduce the issue that you reported.
Confirming your observation: the format that you specify in the Data Module is not how it treats the input, but it specifies how it is rendered.
I would consider this a bug. It seems to treat favour the mm/dd/yyyy parsing, but when it fails it uses dd/mm/yyyy, causing an inconsistent view of the data.
Are you able to log a bug for this?
// Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Mon March 16, 2020 02:46 PM
From: Alex Santamarta
Subject: Dates are duplicated in Data Module by swapping Day and Month
Hello Buddhi,
The problem is that the source of the data are not Excel files, but text files that are using this date format dd/MM/yyyy.
But I think you are right. It seems the data module is expecting that date columns use the MM/dd/yyyy format or yyyy-MM-dd format, not dd/MM/yyyy in any case.
The program that generates the text files would have to be changed to use any of the two valid formats
I naively thought that the format column option in the data module was to specify how the date parts were layed out in the date column of the text file.
------------------------------
Alex Santamarta
Original Message:
Sent: Mon March 16, 2020 02:34 PM
From: Buddhi Gupta
Subject: Dates are duplicated in Data Module by swapping Day and Month
Is it possible to change date format to mm/dd/yyyy in excel to see if that corrects the issue in Data Module?
------------------------------
Buddhi Gupta
Original Message:
Sent: Mon March 16, 2020 02:00 PM
From: Alex Santamarta
Subject: Dates are duplicated in Data Module by swapping Day and Month
Hello,
here the additional information requested:
Cognos Version:
IBM Cognos Analytics 11.1 R5 (Analytics Cloud)
Language Configuration:
Product Language -> English
Content Language -> English
Additionally this is how I formatted the date column in the Data Module:
------------------------------
Alex Santamarta
Original Message:
Sent: Mon March 16, 2020 09:27 AM
From: HENK CAZEMIER
Subject: Dates are duplicated in Data Module by swapping Day and Month
Hi Alex,
Which version of Cognos Analytics are you using?
Could you attach the file as well please?
// Henk
------------------------------
HENK CAZEMIER
Original Message:
Sent: Sat March 14, 2020 03:33 PM
From: Alex Santamarta
Subject: Dates are duplicated in Data Module by swapping Day and Month
I uploaded a very simple text file with two columns, one for the date (in dd/MM/yyyy format) and a second one for the measure.
During the analysis of this file in Cognos Analytics I noticed values for dates that were not in the uploaded text file or dates with duplicated values. And the reason is that the Data Module seems to be swapping days and months for some rows.
As you can see in the screenshots, the sixth row is changed in the data module from first of February to second of January
------------------------------
Alex Santamarta
------------------------------
#CognosAnalyticswithWatson