Grid reports

Applications Grid / Reports
#1

Hi!

I have a question.
I have a grid where one of field is date format (can be before or after current date)
I want to create a report with record “date” will be next year or more.

Thank you

#2

There are php functions to calculate with dates, but scriptcase also has some macro’s to do so. With those functions you can transform dates to the situation you need. Then the result can be used in your sql select statement. Other option is to use sql, but then you need to find the correct syntax for the database you are using. I.e.
select * from orders where order_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);

#3

Thank you!