How to fetch the today date in query tool

[anusha]

I wanted to fecth the today's date automatically for modification date in query tool

" Select [Application]  Where [Modification Date] >= &"Date"  ".

Please help me out on this.

Thanks

[anusha · Accepted solution]

Thank you for your reply.

"&CurrentDate"  works for me.

[hsoegaard]

Its &CurrentDate if I recall correctly

[LMeden]

Hi,
Depending on the date format used on the server where HOPEX is installed:

Select [Application] Where [Modification Date] >="7/17/2017"
I would recommed you use the Query Assistant, remember to enable "see administration properties"