cancel
Showing results for 
Search instead for 
Did you mean: 

using CurrentDate in query for WebGenerate

Solved
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"

 

1 Reply
MEGA Partner

Re: using CurrentDate in query for WebGenerate

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