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)

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?

Outcomes