Finds Start of the month with given date
CREATE FUNCTION [dbo].[StartOfMonth] ( @date datetime ) RETURNS datetime AS BEGIN return DATEADD(M,-1,DATEADD(mm, DATEDIFF(m,0,@date)+1,0)) END
Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags
Why do a need a function for this? You can do this using a calculated field. 🙂
HRNET calculated field does not allow this function stright away, you need to write this in the field anyway.
Anyway, I used this function not in HRNET, but in SQL Server procedures, in the background.