topic Re: Problem using SY-DATUM in (SQL) BETWEEN in Application Development and Automation Discussions

Problem using SY-DATUM in (SQL) BETWEEN

luis_rod — Thu, 07 Jun 2018 17:43:44 GMT

Hi all,

Have the following (pseudo) code:

SELECT myfile~field1 FROM myfile INTO (w_field1) WHERE sy-datum between myfile~begda and myfile~endda

I get a syntax error that states that sy-datum is unknown.

Any ideas?

Thanks,

Luis Rodríguez

Former Member — Thu, 07 Jun 2018 18:14:56 GMT

Hi, you can not use sy-datum in SQL.

check this post

Regards

Miguel

luis_rod — Thu, 07 Jun 2018 18:20:55 GMT

Miguel,

Thanks for the info. It seems a silly limitation. Sigh... Already coded the workaround (not the most elegant of solutions, though).

Thanks again,

Luis