Calendar Month

[josros60]

i Have form with 2 text boxes, one beginning date the other end date.
have button call month when i click should set starint and ending date of month, but it only does
January to February.

here it's the code:

Private Sub cmdmonth_Click()
'Sets the Date From and Date To text boxes
'to show complete month (from start to end of current month)
    Me!BeginDate = CDate("01/" & month(Date) & "/" & year(Date))
    Me!EndDate = DateAdd("d", -1, DateAdd("m", 1, Me!BeginDate))
End Sub

thank you

 

[Joe4]

Are you using an American or Euorpean version of Access?
Sometimes, the different order of date format ("mm/dd/yyyy" versus "dd/mm/yyyy") can cause things to behave a little different than you expect, if you have not properly coded for it.