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

    ExecuteSQL - Return records that are within 30 days.

    madmike6537

      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?