Recent content by revidium

Thanks nameliam. I tested the second one by rolling my date back to 6/1 and it seems to function properly. I never know on forums so I always try to find a post that relates to what I'm doing.

I'm looking for month to date that excludes today. I'm using this formula Between DateSerial(Year(Date()),Month(Date()),1) And Date()-1 This works great except for when it's the 1st of the month. Can anyone give some direction on how to handle the change in months when using this formula?