3 Replies Latest reply on Jun 17, 2012 9:42 AM by Joe Mako

    Connect 2 datasources with custom date?

    Alan Kwan

      Hi all,


      I have 2 data sources they both have date field with time stamp (ie. exact date 03/01/2012 9:23:23AM)


      I want to join the 2 tables together but if I join it by the date field, obviously some records will be missing becuase the time don't match.


      So, I want to join them by DAY instead, ie (03/01/2012 9:23:23AM ---> 03/01/2012 vice versa).


      How could I acheive this?


      Many thanks,