Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: Populating Dates via VBA

    Hi,

    I just need some help regarding populating a table called tblDates using VBA code.

    I just want to populated fields with adding in dates from 01/01/2005 to 31/12/2009.

    The fields I want to populate are
    Date Month Year Day Wk_Commence MonthID Week_Nu
    31/12/2005 December 2005 Saturday 26/12/2005 12 52
    01/01/2006 January 2006 Sunday 26/12/2005 1 1
    02/01/2006 January 2006 Monday 02/01/2006 1 1
    03/01/2006 January 2006 Tuesday 02/01/2006 1 1
    04/01/2006 January 2006 Wednesday 02/01/2006 1 1
    05/01/2006 January 2006 Thursday 02/01/2006 1 1
    06/01/2006 January 2006 Friday 02/01/2006 1 1
    07/01/2006 January 2006 Saturday 02/01/2006 1 1
    08/01/2006 January 2006 Sunday 02/01/2006 1 1


    Thanks for your help in advanced

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    How are you counting weeks? From the first of Jan (irrespective of the day)? And how come you don't go to week 2 for the last record? Please correct the data if there are errors.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •