The below query is giving me results in query studio but when i use this in automation studio it is saying 'error due to system issue'
select applicationDate from Importfile_N WHERE CONVERT(DATETIME, applicationDate, 100) BETWEEN DATEADD(DAY, -17, GETDATE()) AND DATEADD(DAY, -5, GETDATE())
What i have done so far,
- removed PK. all fields are nullable
- made table non sendable
- Cleared my browser cache and cookies
- retried several times
below is my result in query studio which works as intended. Am i missing something here.