Excel → T-SQL › EOMONTH
Excel EOMONTH to SQL EOMONTH
Month-end of order_date is EOMONTH(order_date, 0). Next month start is DATEADD(day, 1, EOMONTH(order_date, 0)).
EOMONTH(order_date, 0)A half-open range [start, next month) beats BETWEEN two EOMONTHs.
Canonical translation
EOMONTH(order_date, 0)Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free