Query for current month and year onward

[tylerg11]

Hi,



I'd like to add criteria to my query to only show records that have a date in the current month and the future. The records are only excluded from the query when the month they are in has passed. Here is what I'm trying to do.

Show all records from our current month (which is currently December 2013) and onward. The moment we flip the calendar to January 2014, the December 2013 records no longer show. So all records show unless the month/year occurs in the past.

[lfpm062010]

Based on what you said.

You can use the Date() or Now() to get today's date and use your date field to compare against.
Something like.

SELECT TABLENAME.SOMETHING
FROM TABLEANME
WHERE TABLENAME.YOURDATEFIELD >= Now();

Note: If you "YOURDATEFIELD" is not DATE/TIME type, you can use function "CDATE" to convert the textstring to an actual date.

SELECT TABLENAME.SOMETHING
FROM TABLEANME
WHERE CDATE(TABLENAME.YOURDATEFIELD) >= Now();