Month of DtPicker

[yasrab]

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.

[RhinoBull]

Trap the error and proceed accordingly; validate Value before formatting...
It basically gets you down to one point: you must handle exceptions.

[DataMiser]

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