Good afternoon.  I am some what new to CR and I have version XI.  I am working with a DB called Cache and it is used with OSC FACS.  I have created a report but I need help with a date range.  I need some help finding the end of the month and how/where it needs to go in the code to put it in the code.  Here is my recode selection formula so far..

I am looking for some code that I can add to my existing code and pull data that has a date starting with the current date and going to the end of the month.  Each month this report will start over and pull all the data from the 1st of the month through the end of the month.  As the days go by, the data will become less and less.  I could do this by saying currentday to currentday + x and let x be the number of days left in the month but I don't want to change the code daily.