cancel
Showing results for 
Search instead for 
Did you mean: 

How to fetch the today date in query tool

Occasional Contributor

How to fetch the today date in query tool

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

3 REPLIES
MEGA Partner

Re: How to fetch the today date in query tool

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"

Highlighted
MEGA Partner

Re: How to fetch the today date in query tool

Its &CurrentDate if I recall correctly

Occasional Contributor

Re: How to fetch the today date in query tool

Thank you for your reply.

"&CurrentDate"  works for me.