HomeActive Query BuilderCan you set a Date criteria to pull yesterday's data only?

Can you set a Date criteria to pull yesterday's data only?


I need to generate a daily report that will always retrive data from the day before. How is this possible using Query builder?
Grace P | email
March 13 2009, 11:06 AM
This is possible if your database server supports such expressions like "YESTERDAY" or "TODAY-1". These expressions should be placed into the "Criteria" column of the appropriate date field as ordinary date constants. Please refer to your database server SQL reference to learn more about working with dates.
Sergey Smagin | email
2 days, 15 hours since original post
This topic is closed