using CurrentDate in query for WebGenerate

[farhad]

Hi

given query below which works fine if run that query but giving error (attachaed screen shot) when using that query in website.

Could you help me on this..

Query:

Select [Library] Into @publib1 Where [Legacy Parent Library].[Absolute Identifier] Deeply ="zFtPWEd4LnKN" Or [Absolute Identifier]="zFtPWEd4LnKN"

Select [Organizational Process] Into @app_process_validated Where [Owner Architecture Container]:[Library]="[B. Forretning Arkitektur]" And [Organizational Process Status]="VAL" And [End of Validity Date]>&"CurrentDate"

[hsoegaard · Accepted solution]

You cant use an Operator directly in q Query. In this case you would have to attach a Macro to the Query which tests if the CurrentDate is greater than the End of Validty date