Question

How to order an array of dates by year descending and then by month descending in VB.NET

Answer 1

Imports System
Imports System.Linq

Public Class Program
	Public Shared Sub Main()
        Dim dates = New DateTime() {
			New DateTime(2022, 5, 1), 
			New DateTime(2022, 12, 1), 
			New DateTime(2022, 9, 1), 
			New DateTime(2022, 2, 1), 
			New DateTime(2023, 1, 1),
			New DateTime(2023, 3, 1)}
		
        Dim result = From d In dates Order By d.Year descending, d.Month descending Select d

        For Each dt As DateTime In result
            Console.WriteLine(dt.ToString("yyyy/MM/dd"))
        Next
    End Sub
End Class




' run:
'
' 2023/03/01
' 2023/01/01
' 2022/12/01
' 2022/09/01
' 2022/05/01
' 2022/02/01
' 

 

70+ SQL courses for beginners and professionals