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,

      Alan