SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date

I calculate the FIRST and LAST Day of Current Date using explicit date boundaries. The historical sample starts on October 28, 2017.