hi ya ,

i worked out how to do it.

on the join, i used 'between'

ie. on period between issue date and expiry date.

the query needs to be dynamic so I don't want to hard code anything. The data will be pulled into month end reporting.

The idea of it is to return all...

it is supposed to return rows which have dates less than 30th of June