this is great, thanks much!!

thought I could just create a global variable with it and reference the variable name each time I need that value instead of typing this whole...

oh I see, thanks for your reply, you surely did help me learn something new about SQL server.

I wanted to create a variable, which is the first day of the...

oh I see, that makes sense.

Thank you so much, I learned something new today!!