Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
When I compare the Month and year in DateColumn1 against DateColumn2, it should tell me that DateColumn1 is less (i.e, earlier) than DateColumn2, even though the Month October in DateColumn1 is a later month compare to Jan, theDatColumn1 is in the past year and DateColumn2 is in the current year.
Case 1: For Eg DateColumn1 = '01-OCT-2013' DateColumn2 = '01-JAN-2014'
Here it should tell me that the difference is 0 as the month and the year match in this case.
Case 2: DateColumn1 = '01-JAN-2014' DateColumn2 = '02-JAN-2014'
Here it should tell me that the DateColumn2 is lesser than DateColumn1.
Case 3: DateColumn1 = '01-Aug-2014' DateColumn2 = '02-JAN-2014'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.