I've used this technique many times to help grab the beginning and end of a month. It's useful for queries where you need to use a BETWEEN. [crayon-5b75e0a3e3e60784284356/] Sample usage: [crayon-5b75e0a3e3e6e380636898/] I hope this is helpful to you in your querying adventures. Got another way to accomplish the task? I'd love to hear from you. Post a comment below.