this code produces this (UK date format), US will be month/day
?dateadd("m",1,dateadd("d",-day(date),date)+1)
01/03/2020
?dateadd("m",2,dateadd("d",-day(date)+1,date))-1
31/03/2020
Thanks everyone for your help.. unfortunately I have patient information so i am unable to share my database or query.. I will just run a query and update it monthly to run between #date# and #date#. Thank you.