Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

week number

Discussion in 'Information Technology' started by Keith, Nov 9, 2005.

Tags:
  1. Keith

    Keith
    Expand Collapse
    Guest

    Is there a way to find out the week number from a date?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Valley Children Learn Punjabi/Sikh Dance And Culture At 2-week Camp Breaking News Jul 20, 2016
    Another week, another wolf Blogs Oct 17, 2015
    the weekend. Blogs Oct 17, 2015
    What a week..... Blogs Oct 17, 2015
    Shabad Of The Week: Bāvre ṯai Gi▫ān Bīcẖār Na Pā▫i▫ā Shabad of the Week Jun 2, 2014

  3. Terry

    Terry
    Expand Collapse
    Guest

    Hi Keith,

    Lookup help on Format$.

    Regards


    "Keith" <keith@dolby-ltd.co.uk> wrote in message
    news:dkqgju$a60$2@news0.ifb.net...
    > Is there a way to find out the week number from a date?
     
  4. DBS

    DBS
    Expand Collapse
    Guest

    Try using the DatePart function. For example:

    Dim intWeekNum As Integer

    intWeekNum = DatePart("w", MyDate)

    Be sure to read up in Help about DatePart. It include optional arguments to
    specify firstdayofweek and firstweekofyear, which would have an impact on
    what it returned.

    Hope that helps!

    David


    "Keith" wrote:

    > Is there a way to find out the week number from a date?
    >
     

Share This Page