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?