Community discussion forum

Accounting Periods

  • 6 months ago

    Hello Programmers, I need to figure out how to create accounting periods (ie., monthly, quarterly and yearly) using VB with Visual Studio 2008 and SQL Server. Thanks for any assistance!

    Post was edited on 24/05/2009 15:21:37 Report abuse
  • 6 months ago

    yes u can create it....This is code by how u can get which is the quarter from given date

    Public Function getFinancialYear(ByVal dt As Date) As String 'If DatePart(DateInterval.Quarter, dt, FirstDayOfWeek.Sunday, FirstWeekOfYear.Jan1) = 1 Then Dim FinDate As Date = Convert.ToDateTime(dt).ToString("dd/MM/yyyy") If DatePart(DateInterval.Quarter, FinDate) = 1 Then //first quarter ----jan 01 to 31st marc
    Else //second/third/fourth quarter End If End Function

  • 6 months ago

    Thank you Viral... I'll let you know how it goes.

Post a reply

Enter your message below

Sign in or Join us (it's free).

Want to stay in touch with what's going on? Follow us on twitter!