I am trying to query a balance by EFFDT for the prior month, so that if I run the query 05/05 it should return values 04/01 - 04/30, or if I run the query 06/12 I should get the ones with an effective date from 05/01 - 05/31. Any suggestions are welcome. Thank you