mcpacific Posted June 9, 2014 Share Posted June 9, 2014 Does anyone know how to use the SQL Helper functions to do a select_query that includes a date range? The documentation only shows "LIKE" and "NEQ" as sqltypes. What about BETWEEN or >=? I would like to query records that were created during the past 30 days (using a fieldname 'date'). 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 9, 2014 Share Posted June 9, 2014 take a look at the code in the reports pages - /modules/reports/ - they're not encrypted, so they should be able to help you in the right direction. 0 Quote Link to comment Share on other sites More sharing options...
mcpacific Posted June 9, 2014 Author Share Posted June 9, 2014 Cool thanks 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.