cancel
Showing results for 
Search instead for 
Did you mean: 

using CurrentDate in query for WebGenerate

Highlighted
MEGA Partner

using CurrentDate in query for WebGenerate

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"