Month of DtPicker-VBForums
Results 1 to 3 of 3

Thread: Month of DtPicker

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2011
    Posts
    74

    Month of DtPicker

    the Dtpicker format to show on the form is custom that is MMMM/yyyy.

    now whenever change the value of dtpicker by its "change" function then if it has january and i increase its value to february then it shows february to view but the value it gives will be March in the below syntax:

    Mnth = format(dtpicker1.value , "MMMM")

    this bug only arise if the day value of january will be 31.

    any sugestion.

    also wat is the query for taking month and year from a date field of access.

  2. #2

  3. #3
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    8,260

    Re: Month of DtPicker

    Maybe it has nothing to do with January 31st since this occurs every year.
    Perhaps it is struggling with the fact that Febuary has 29 days this year.
    Maybe jumping from end of January to end of Febuary but then mistaken Feb 29 for Mar 1

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.