AnsweredAssumed Answered

ExecuteSQL - Return records that are within 30 days.

Question asked by madmike6537 on Feb 21, 2017
Latest reply on Feb 22, 2017 by beverly

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)



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?