Edit Column Formula to get the records with Due date between two dates

Content

Hi there,

I am using the Edit Column Formula with the Due Date to get only the records between two days. - today and 7 days ago.

I m trying this but without success. What am I doing wrong?

Thanks in advance

Bobby

 

SELECT "General Information"."Due Date" BETWEEN TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) FROM "Workforce Learning - Learning Records Real Time" AND CURRENT_DATE FROM "Workforce Learning - Learning Records Real Time"

 

 

the error I get

Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27002] Near