How to Handle Calculations Related to fiscal year and quarter

  • bpatin

    SSC Enthusiast

    Points: 180

    While I have used BETWEEN in many places, there may be a problem missing the last second or minute of the day when the time is included, and it depends on whether the value is a datetime or a smalldatetime. So something like WHEN ClosedDate >= @FromDate AND < @ToDate, where @ToDate is midnight on the first day of the next quarter, would be more accurate than using BETWEEN.

Viewing post 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply