Results 1 to 3 of 3

Thread: To find out no of weeks in a month

  1. Feb 7th, 2000, 04:32 PM #1
    Murali
    Murali is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 1999
    Location
    chennai,tamilnadu,india
    Posts
    29

    Post

    Hi ,

    Is there any vb function or any logic To find out no of weeks in a month.I/p is Month name

    Thankx
    Murali
    Reply With Quote Reply With Quote
  2. Feb 7th, 2000, 05:47 PM #2
    Buzby
    Buzby is offline
    Frenzied Member Buzby's Avatar
    Join Date
    Jan 1999
    Location
    UK
    Posts
    1,670

    Post

    I haven't tested it but you could try this;

    StartOfMonth="01/02/2000"
    NoOfWeeks = Datediff("ww",StartOfMonth,DateAdd("m",1,StartOfMonth))



    ------------------
    Mark "Buzby" Beeton
    VB Developer
    [email protected]


    Reply With Quote Reply With Quote
  3. Feb 8th, 2000, 12:10 PM #3
    Murali
    Murali is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 1999
    Location
    chennai,tamilnadu,india
    Posts
    29

    Post

    Hi Buzby
    Thanks it is working fine
    Regards
    Murali
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width