Printable View
I'm relatively new to using VB but I'm trying to design a small program that has a lot of SQL involved in it that someone else wrote. What I'm trying to do is to do a date selection of 7 days at a time, and pass that as a variable to another form for processing. I've never used the MonthCalendar control before and was wondering what would be the best method for getting the date and passing that as a variable to another form that will depend on that data.
Thank you,
Doug
Welcome to the forums. :wave:
MonthView1.Value would contain the date selected.
But, if you need a data range, then you would need to select two dates, which makes it a bit more tricky (how does the MonthView control know which date you are selecting - start or end?)
Do you have a working query that "someone else wrote" that you are trying to modify to fit your own needs?
Hack,
Thank you for your response but I would need a date range. Maybe the date/time picker would be a better option? Or maybe just a date entry field (in a text box) that allows users to enter start/end date. The sql query is written already (and it works in it's current form) but the data that I'm gathering with the start/end date is added to the beginning of the SQL query, stored as an integer and passed to the next form.