I want to add a column to my dataset that contains the returned bDay from the NextBday function. Is that possible. This may look familiar to some of you because I attempted to do something similar with ZipCodes a while back. However I never found a proper solution for that problem and used a quick hack to get by for the time.

VB Code:
  1. Function NextBday(ByVal aDOB As Date) As Date
  2.         Dim bDay As New Date(Date.Today.Year, aDOB.Month, aDOB.Day)
  3.         If bDay <= Date.Today Then
  4.             bDay = bDay.AddYears(1)
  5.         End If
  6.         Return bDay
  7.     End Function
  8.  
  9.     Function GetBirthdays() As DataSet
  10.         Dim strCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  11.             "DATA Source=c:\data\info.mdb")
  12.  
  13.         Dim dtDateStart As Date = Date.Today
  14.         Dim dtDateEnd As Date = dtDateStart.AddDays(30)
  15.         Dim conn As OleDbConnection = New OleDbConnection(strCon)
  16.         Dim strSelect As String = _
  17.             "Select Store, Name, bDate From UeosBday Where " & _
  18.             "bDate >=" & dtDateStart & " And " & _
  19.             "bdate <=" & dtDateEnd & " Order by bDate"
  20.  
  21.         Dim Cmd As New OleDbDataAdapter(strSelect, conn)
  22.         Dim ds As New DataSet
  23.         Cmd.Fill(ds, "bDays")
  24.  
  25.         With ds
  26.             ' I am looking for a way to run every bDate in
  27.             ' the ds through the NextBday function. The purpose
  28.             ' of this is to find the next birthday of each employee
  29.             ' in a 30 day period.
  30.  
  31.             ' For instance if a persons birthday is 9/12/1969 the
  32.             ' function brings it current by making it 9/12/200x
  33.             ' and then compares it to todays date. If todays date
  34.             ' is later then the returned date it adds a year. If not
  35.             ' it just returns the converted date (9/12/2006).
  36.         End With
  37.  
  38.         ' Is there a better way to do this then the way I am attempting it?
  39.  
  40.         Return ds
  41.  
  42.     End Function