Announcement

Collapse
No announcement yet.

table compare: date column does not recognise different formats

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • table compare: date column does not recognise different formats

    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
    Attached Files

  • #2
    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.
    Chris K Scooter Software

    Comment


    • #3
      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?

      Comment


      • #4
        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 support@scootersoftware.com and I'll share them with our developers.
        Chris K Scooter Software

        Comment


        • #5
          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"

          Comment


          • #6
            Thank you for sharing the examples, I'll pass them on to our development team.
            Chris K Scooter Software

            Comment

            Working...
            X