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

Sourav Kumar Das

8y1.2k.NET

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...

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
@sourav, you need to show the tables and the expected output
Sourav Kumar Das8y ago
If there's a solution please send me.......
Sourav Kumar Das8y ago
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....
Sourav Kumar Das8y ago
Yes I have tried it...it didn't come...

@ Amit Gupta
Sourav Kumar Das8y ago
Yes I have checked out the second URL....
but it doesn't meet the conditions...

@ Dhammapal Kamble
Dhammapal Kamble8y ago
have u check second url it is for max and min date
Amit Gupta8y ago
Have you tried using
Select max(columnName), min(columnName)
from tablename
Sourav Kumar Das8y ago
If there's a solution please send me......
Dhammapal Kamble8y ago
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