http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 28 May 2026 08:16:12 +0000 Fri, 01 Apr 2011 14:49:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=18148 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=18148&PID=63674&title=start-and-end-date-in-datepicker#63674 Author: SuperMario
Subject: 18148
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
]]> Fri, 01 Apr 2011 14:49:23 +0000 http://forum.codejock.com/forum_posts.asp?TID=18148&PID=63674&title=start-and-end-date-in-datepicker#63674 http://forum.codejock.com/forum_posts.asp?TID=18148&PID=63659&title=start-and-end-date-in-datepicker#63659 Author: vollweise
Subject: 18148
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]]> Fri, 01 Apr 2011 02:56:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=18148&PID=63659&title=start-and-end-date-in-datepicker#63659