Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Dali » To partially Match cell against another partial cell
To partially Match cell against another partial cell [message #1773695] Tue, 03 October 2017 07:11
Nagesh Kumar is currently offline Nagesh KumarFriend
Messages: 4
Registered: September 2017
Junior Member
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.
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
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?
Nagesh Kumar

[Updated on: Tue, 03 October 2017 07:13]

Report message to a moderator

Previous Topic:Can't create connection to SQL Server
Next Topic:Integer instead of int
Goto Forum:

Current Time: Sat Mar 24 22:00:50 GMT 2018

Powered by FUDForum. Page generated in 0.01907 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software