Thanks ballardw ... View more

Thanks Hai.kuo, That works perfectly, can you explain what 'best' is doing? Thanks ... View more

Thanks Hai.Kuo, I should have mentioned I'm using the query builder & creating an Advanced Expression. Is it possible to advise an expression to do this?' ... View more

Thanks After a lot of testing the functions, I used DATDIF to manually subtract the date field value from 1st Jan 1960 which gave me a number, I could then match these number fields. I think that's what you were trying to tell me Reeza. This is a lot of messing about to sort such a simple issue out??? I thought I'd just have to truncate the HH:MM:SS off the date Time field & I'd get matches, but no ...  I used datepart to change the date from a normal date format to a number on the date/time field & then create a number from a date using datedif for the other table.   DATDIF('01jan60'd, my_date_field ,'act/act'). Thanks to both of you - surely there's an easier way ??? ... View more

So, if that's the case, what do I need to do to fix this? ... View more

Thanks Reeza, I've already tried changing the values to match as I stated at the start. "I've tried changing the format of the Oracle date/time format to just date 'DDMONYYYY' in order to match the Teradata table but I still get no matches." I tried applying a Format to both fields such as 'DDMMYYN8.' but still no matches even though the values look identical on the tables?? ... View more

Thanks again, You're right, I am using the query builder & I've used the datepart function as datepart(Fieldname) which I tested on one value that I know matches. Only thing is that it has changed the date to 19521 which I understand to be the number of days since 1st Jan1960. This isn't going to match a date format in my other table though ?? What do I do from here? ... View more

Thanks Hai.kuo, but I don't know what you mean. Can you elaborate with maybe an example? Thanks ... View more