To partially Match cell against another partial cell

To partially Match cell against another partial cell

  

I have a problem with two tables which I need to compare dates for the same reference. The problem is that a) the dates are different formats and b) superfluous data is also contained within both date cells.

Global

No. Date
1   1992-08-25 00:00:00.000
2   2015-05-19 00:00:00.000
3   2000-01-12 00:00:00.000

Local

No. Date
1   25.08.1992 00:00:00.000000000 GMT
1   28.08.1992 00:00:00.000000000 GMT
2   19.05.2015 00:00:00.000000000 GMT
3   12.01.2000 00:00:00.000000000 GMT
3   17.01.2000 00:00:00.000000000 GMT

Note that the date formats between the two tables differ and contain lots of time and zero data that is not needed. So ideally I would like to see the format as DD-MM-YYYY.

I would like to return only the Global and Local entries where the Local date differs from Global date. So from the data above, I would want to see:

No. Date        No. Date
1   25-08-1992  1   28-08-1992
3   12-01-2000  3   17-01-2000

I would put my attempts so far, but to be honest I have no idea on how to tackle the partial cell matching and re-formatting.

Any ideas?

Thanks

Saanvi S

convert the dates (and strip the time if needed)

the rough fix would be something like stripping the time (so substr the first 10 character)

replace the dots with - and you are able to compare stringwise


J. wrote:

convert the dates (and strip the time if needed)

the rough fix would be something like stripping the time (so substr the first 10 character)

replace the dots with - and you are able to compare stringwise



Thank you for your quick response.