compare 2 datesLLlyealain loon18yAsked Mar 14, 2008, 2:59 AM2.2kVisual Basic .NET hi i tried to compare 2 dates where i stored both in databaseboth dates are in mm/dd/yyyy format as varchar in databasecmd.CommandText = "select birthday from contact where birthday- reminder <= 7";how do i run that query ?thanks
RARyan Alford18y agoPosted Mar 14, 2008, 1:49 PMyou can't. since they are stored at strings in the database, you can't do mathematic equations on strings.you will need to write the query to return both values, convert them to dates in C#, then compare.0
Ryan AlfordPosted Mar 14, 2008, 1:49 PM
you will need to write the query to return both values, convert them to dates in C#, then compare.