Accounting Periods

• • Reply

  11 years ago

  by lwestj

  lwestj

  USA, United States

  Joined 16 years 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!

  Report abuse
• • Reply

  11 years ago

  by viral.mat

  Viral Gandhi

  Ahmadabad, India

  Joined 11 years 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

  Report abuse
• • Reply

  11 years ago

  by lwestj

  lwestj

  USA, United States

  Joined 16 years ago

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

  Report abuse