.Net DateTime fiscal Quarter

Question

Does anyone know how to construct a DateTime in .NET to be the first day of the current quarter?

Answer 1

        var currentTime = DateTime.Now;
        var year = currentTime.Year;
        DateTime[] quarterStarts = {new DateTime(year, 1, 1), new DateTime(year, 4, 1), new DateTime(year, 7, 1), new DateTime(year, 10, 1)};
        var currentStart = quarterStarts.Where(s => s < currentTime).Last();

Answer 2

@yogesh is right, here's what I use in a sql sp:

CREATE FUNCTION [dbo].[fn_startOfQtr](@dt DATETIME) 
RETURNS DATETIME AS  
BEGIN 
    declare @ret DATETIME
    declare @qtr int

    set @qtr = ((month(@dt)-1)/3)+1
    set @ret = cast(str(@qtr * 3 - 2) + '/1/' + str(year(@dt)) as DATETIME)
    return @ret
END

Answer 3

public DateTime GetCurrentQuarter(DateTime date)
{
    int startingMonthOfQuarter = (((date.Month - 1) / 3) * 3) + 1;

    return new DateTime(date.Year, startingMonthOfQuarter, 1);
}