IBM connection error as400

[Danielht]

Hello community !!

I have a problem. I am connected with a IBM as400 in designer, when I use the input tool --> SQL Editor and I write a part of code:  GetDate(), Alteryx shows a error : IBMDA400 Command: SQL0204: GETDATE ....

The complete code is:

select * from  dbo.SOFBF70 where Day(GetDate() - 3) <= dbo.SOFBF70.DIAOPE

dbo. SOFBF70 is my table and DIAOPE is my field for filter.

I attach the error in a image

Help me

Thanks.

[Thableaus · Accepted solution]

Hi @Danielht 

Could you try to use CURRENT DATE instead of Getdate()?

Cheers,

[Danielht]

Thanks friend!

[Danielht]

HI again @Thableaus !

 I have a new problem, could you see this link please?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/concat-columns-and-then-convert-to-dat...

Maybe you have the solution

Cheers.