hi I have table in database that one column is Expiredate that save date like below20151123now I want compare it whit today date like below if dr34ExpireDate34ltDateTimeNow but it makes error can you tell me true code for itbest regardsneda

you can use below codeCifConvertToDateTime dr34ExpireDate34 lt DateTimeNow

Compare date from Database with Current Date using C# .Net

nedash

hi I have table in database that one column is Expiredate that save date like below

2015-11-23

now I want compare it whit today date like below:

 if (_dr["ExpireDate"]<DateTime.Now)
                    {
                       
                    }

but it makes error can you tell me true code for it?

best regards

neda

Shashika...

0 1

you can use below code.

if(Convert.ToDateTime( _dr["ExpireDate"]) < DateTime.Now)
{
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html