Date comparison with MaxValue not working

Question

I have a nullable Date property called BoughtDate. I am trying the following:

if( item.BoughtDate.Value.Equals( DateTime.MaxValue) ) item.BoughtDate= null;

also tried this:

if( item.BoughtDate.Equals( DateTime.MaxValue) ) item.BoughtDate=null;

When debugging, my BoughtDate and DateTime.MaxValue seems exactly the same - yet it says it is not the same(does not set my item.BoughtDate to null)

Why does my comparison not work?

user_5224627 · Answer

I think you might find answer in the below link if the Date you are fetching from SQL-Server. SQL-Server only supports the time range till 23:59:59.997 and this might cause few ticks less than what C# supports. You can just compare the dates as @Pikoh already mentioned.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql

Date comparison with MaxValue not working

4 Answers