1 Reply Latest reply on Feb 22, 2016 12:00 AM by Bora Beran

    Date - Help needed in sql logic

    soundari anand

      Hi all, I need help in constructing a logic

       

       

      IF ([Contact Created Date] >= [Fiscal Date] THEN 'N' ELSE 'Y' END

      This was used till last week and was working fine.

       

      Now i have a scenario, that the Contact Created date is updated one day later in the system and my results are getting wrong.

       

      pls help me in the sql logic change.