[SOLVED] SQL statement GRID APP

Applications Grid / Reports
#1

Help, how do I configure a SQL statement GRID I show only the record of the current date.

example:
SELECT title, fecha_vencimiento FROM contacs WHERE fecha_vencimiento = current date

or

SELECT title, fecha_vencimiento FROM contacs WHERE fecha_vencimiento <current date

Thank you.

#2

Re: SQL statement GRID APP

Put a variable in the onLoad event:
[current_date} = date(Y-m-d);

Then do your select

SELECT title, fecha_vencimiento FROM contacs WHERE fecha_vencimiento = ‘{current date}’;

#3

Re: SQL statement GRID APP

SELECT … WHERE fecha_vencimiento = CURDATE();

jsb

#4

Re: (SOLVED) SQL statement GRID APP

Thanks for the help, both options are correct, but that best suits my needs was the suggestion of jsbinca.

It worked perfect thanks.

#5

Re: SQL statement GRID APP

OK, no problem for me :slight_smile:

will try if jsbinca?s solution will work for me too !

PS: that?s why the forum is such important !