Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2017
    Posts
    3

    Default 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 Images Attached Images

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,683

    Default

    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

  3. #3
    Join Date
    Nov 2017
    Posts
    3

    Default

    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?

  4. #4
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,683

    Default

    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

  5. #5
    Join Date
    Nov 2017
    Posts
    3

    Default

    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"

  6. #6
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,683

    Default

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •