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.