If you are using BO, then you could create a simple report in either Web Intelligence or Desktop intelligence using this field. Then look at the sql it suggests without actually looking at it.
I would image that you have a startdate and an end date for each period and you would use that in a between clause, but without seeing the schema it's difficult to say.
hth
Rich