Results 1 to 3 of 3
  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2011

    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
    Join Date
    Feb 2012
    West Virginia

    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


Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.