Getting of Max and Min Dates from SQL in Asp.Net

Question

How to get Minimum and Maximum dates from SQL Server and placing it in DateTime Picker strip...by using Asp.Net Example: SQL Query has two dates like 01-11-2018 and 10-11-2018. In Asp.net Datetimepicker I need to get those two date values in datetime picker..? If there's a solution please send me...

Amit Gupta · Answer

Have you tried using Select max(columnName), min(columnName) from tablename

Sourav Kumar Das · Answer

For my above question I will give you a clear idea.... A Scenario. Like Project Manager assigns Projects-1 to Team Leader. (The Project-1 has its feilds such as projectid, projectname, projectdesc, clientname, modulename, startdate and enddate) Then Team Leader assigns the Project-1 to the teammates (have 4 members) by giving the Tasks. The Tasks has Projectname, taskname, modulename, assignedto, assigneddate, taskdesc, etc.., Where assigned date is used as datetimepicker. In this assigneddate should have the startdate and enddate in datetimepicker of the Project-1 If there's a solution please send me....

Amit Gupta · Answer

@sourav, you need to show the tables and the expected output

Sourav Kumar Das · Answer

If there's a solution please send me.......

Sourav Kumar Das · Answer

Yes I have tried it...it didn't come... @ Amit Gupta

Sourav Kumar Das · Answer

Yes I have checked out the second URL.... but it doesn't meet the conditions... @ Dhammapal Kamble

Dhammapal Kamble · Answer

have u check second url it is for max and min date

Sourav Kumar Das · Answer

If there's a solution please send me......

Dhammapal Kamble · Answer

If you want to set date to datetimepicker then need to convert date to datetime object assign that object to datetimepicker.value = new DateTime(2012,05,28); reference https://stackoverflow.com/questions/541225/how-can-i-set-a-datetimepicker-control-to-a-specific-date for min max dates https://www.w3resource.com/sql/aggregate-functions/max-date.php

Getting of Max and Min Dates from SQL in Asp.Net

Answers (9)