compare date error
-
hi i tried to compare 2 dates where i stored both in database both dates are in mm/dd/yyyy format cmd.CommandText = "select birthday from contact where birthday- reminder <= 7"; how do i run that query ? thanks
If you are using Sql Server 2005 you can use DateDiff[^]
Giorgi Dalakishvili #region signature my articles #endregion
-
hi i tried to compare 2 dates where i stored both in database both dates are in mm/dd/yyyy format cmd.CommandText = "select birthday from contact where birthday- reminder <= 7"; how do i run that query ? thanks
U can Put the value of Birthday and Reminder on Veriable then U can Easily Companre . Else u can use Datediff function :~9250168195 anubhava.prodata@gmail.com
-
hi i tried to compare 2 dates where i stored both in database both dates are in mm/dd/yyyy format cmd.CommandText = "select birthday from contact where birthday- reminder <= 7"; how do i run that query ? thanks
U can Put the value of Birthday and Reminder on Veriable then U can Easily Companre . Else u can use Datediff function Anubhava Dimri 9250168195 anubhava.prodata@gmail.com
-
U can Put the value of Birthday and Reminder on Veriable then U can Easily Companre . Else u can use Datediff function Anubhava Dimri 9250168195 anubhava.prodata@gmail.com
-
Put the Value of Date in DateTime Variable Then U can easily deduct date value Like Dim var_date as datetime Var_date = "2/13/2008" var_Date = Var_Date.days - 3 Anubhava Dimri 9250168195 anubhava.prodata@gmail.com