8 Replies Latest reply on Feb 22, 2017 8:08 AM by beverly

    ExecuteSQL - Return records that are within 30 days.


      Hi all,


      I am trying to use ExecuteSQL to return records with a date within 30 days. I know there are some differences between SQL dates and FM dates and I just cant get it to work.


      I have tried:


      WHERE(date_created >= CURRENT_DATE - 30)

      WHERE(date_created >= CURRENT_DATE - INTERVAL 30 DAY)


      and several others, but I am either getting a syntax error or it just doesnt return the right results.


      Any suggestions? I can make my date field be whatever I want because its sole purpose is this search so only records within 30 days old are synced. So I can make it text, or put it in SQL format if that helps?