Start and End Date in DatePicker

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   

How can I start date and end date
  the date picker with VB or VBA query

 Private Sub DatePicker2_SelectionChanged ()
     MsgBox start date
     MsgBox end date
 End Sub

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
vollweise Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 25 February 2010 Location: Germany Status: Offline Points: 14	Post Options Post Reply Quote vollweise Report Post Thanks(0) Quote Reply Topic: Start and End Date in DatePicker Posted: 01 April 2011 at 2:56am
	How can I start date and end date the date picker with VB or VBA query Private Sub DatePicker2_SelectionChanged () MsgBox start date MsgBox end date End Sub
	Michael Ricklefs

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 01 April 2011 at 2:49pm
	If you allow non-continuous selection then you will need to refine your query, each selection is know as a block. Here is code assuming 1 continuous block: Private Sub wndDatePicker_SelectionChanged() If wndDatePicker.Selection.BlocksCount = 1 Then Debug.Print wndDatePicker.Selection.Blocks(0).DateBegin Debug.Print wndDatePicker.Selection.Blocks(0).DateEnd End If End Sub