Linq query to find Smallest and largest date in an array of dates

Help Studio
1

i have an array of dates in which i want to find the start(smallest date) and end date (latest date), Kindly help

2

@Amrutha.mg

arrdates.Min and arrdates.Max

The image displays a debug view of an array of DateTime values, showing the minimum and maximum dates along with the full list of dates. (Captioned by AI)
The image displays a debug view of an array of DateTime values, showing the minimum and maximum dates along with the full list of dates. (Captioned by AI)745×247 3.95 KB

if string array then use function inside to get min and max

image

cheers

3

Hi @Amrutha.mg

startDate = dateArray.Select(Function(d) DateTime.Parse(d)).ToArray().Min()
endDate = dateArray.Select(Function(d) DateTime.Parse(d)).ToArray().Max()

Regards,

4

Thank you this helped me a lott :slight_smile:

1 Like
5

thank you this helped me :slight_smile:

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.