Community discussion forum

Accounting Periods

• • Reply

  6 months ago

  by lwestj

  lwestj

  USA, United States

  Joined 5 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!

  Post was edited on 24/05/2009 15:21:37 Report abuse
• • Reply

  6 months ago

  by viral.mat

  Viral Gandhi

  Ahmadabad, India

  Joined 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

  Report abuse
• • Reply

  6 months ago

  by lwestj

  lwestj

  USA, United States

  Joined 5 years ago

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

  Report abuse