I have a field called "actual_month" and based off a date in another field called "start_date" this field is set with specific text as follows using the case function
if the date in "start_date" falls for instance between 5/5/2018 and 7/6/2018 this would be classed as "actual_month" being "May - 2018" but as you can see the dates are not from the 1st to the 31st of May.
I need to create a way to be able to search for instance for records that are now between actual_months based on the values set in the actual_month field i.e. from "Jan - 2017" to "May - 2018" but as you can see the dates that set these values are not from the 1st of a month to the end of a month as I stated above.
If I have a report, is there a way on the report if a person chooses from 4 fields listed below to be able to find all records that have the month name and year set in the field? i.e.
Start Month = "Jan""
Start Year = "2017"
To Month = "May"
To Year "2018"