table compare: date column does not recognise different formats

[jacques8]

Hi,

I have set the column manually to type 'date'
The value "2017-11-24" is not recognized as being the same as "24-nov-2017" (it stays marked in red)
How can I tell BC3 to recognize the date format?

Also: both values are shown in red with strikethrough. see attachment. what does the strike through mean?

thank you

[Chris]

Strikethrough indicates a cell doesn't match the defined column type. For a date column, it indicates the cell doesn't match the expected format of a date.

When a column is defined as a date, Beyond Compare uses the Short Date format defined in the Windows Regional Settings. On a US English system, the short date is MM/DD/YYYY.

If you don't want to see strikethroughs when a date column doesn't match the system short date, change the column type to text.

[jacques8]

thank you for explaining. Would be nice if BC would allow me/user to define the date format (and in this case, a different format per source file) - is that feature on the backlog somewhere?

[Chris]

Thank you for the suggestion. User defined date formats are on our todo list for an upcoming version of BC. If you have example files you can share with date columns that are problematic in the current version of BC, please send them to [email protected] and I'll share them with our developers.

[jacques8]

Here are a few lines with cleaned data for each file:

the first file has data like this:

ID,Exposure,Exposure As Of,Start Date,End Date
65636,24056.72,2017-11-24,2017-04-11,9999-12-31
65637,-49905.76,2017-11-24,2017-04-11,9999-12-31
65944,63350.70,2017-11-24,2016-09-12,9999-12-31
65945,-6711.67,2017-11-24,2016-09-12,9999-12-31

the second file has data like this:
"ID","Exposure","Exposure As Of","Start Date","End Date"
"65636","24056.72","24-Nov-2017","11-Apr-2017","31-Dec-9999"
"65637","-49905.76","24-Nov-2017","11-Apr-2017","31-Dec-9999"
"65944","63350.70","24-Nov-2017","12-Sep-2016","31-Dec-9999"
"65945","-6711.67","24-Nov-2017","12-Sep-2016","31-Dec-9999"

[Chris]

Thank you for sharing the examples, I'll pass them on to our development team.