3 Replies Latest reply on May 26, 2016 6:02 AM by Tharashasank Davuluru

    Getting error while comparing two date columns coming from different source.

    savita khyadi

      Hi All,

       

      I have a scenario where I have to compare the date field which are coming from two different sources.

      One from SQL and other from excel. am trying to create a calculated field like MONTH(SQL Date field)= Month(Excel Data) am getting error like cant compare integer and string values.(I made sure that both the date fields follow same format of date represenatation)

      I just want to compare the dates in both the sources and if it matches the result should be "Yes" if not then "No".

      I tried doing data blending also but it didnt work. Any other solution? Please advise.

       

      Many Thanks