No announcements
Found 379161 threads
-
0 Votes
compare date
List<DateTime> dates= new List<DateTime>(); dates.Add(date1); dates.Add(date2); dates.Add(date3); DateTime ...Answered | 4 Replies | 3396 Views | Created by viki2 - Monday, July 20, 2009 2:09 AM | Last reply by Sekar Perumal - Monday, July 20, 2009 3:47 PM -
1 Votes
Unable to compare two dates
You can compare dates without converting them to string by comparing within range of dates between today's date and tomorrow's date.Answered | 1 Replies | 3785 Views | Created by Saadi.A - Thursday, October 28, 2010 10:14 AM | Last reply by VMazur - Thursday, October 28, 2010 10:29 AM -
1 Votes
Comparing dates
While your query will work with string dates, as shown above using datetime functions, it would be faster to use DATE type (SQL Server 2008) if time is not needed like in BirthDate.Answered | 9 Replies | 4186 Views | Created by blacksaibot - Thursday, November 17, 2011 6:36 PM | Last reply by Kalman Toth - Sunday, November 20, 2011 12:50 PM -
1 Votes
Compare Date strings
Hi, I would definitely compare these as DateTime and not as strings.Answered | 4 Replies | 3716 Views | Created by William256 - Thursday, August 5, 2010 2:46 PM | Last reply by Meile Zetstra - Thursday, August 5, 2010 3:23 PM -
2 Votes
Can't compare dates
Hi Lsmor, In Analysis Services, we can only compare numeric values in condition.Answered | 1 Replies | 592 Views | Created by Lsmor - Thursday, August 25, 2016 7:35 AM | Last reply by Simon_Hou - Thursday, August 25, 2016 12:37 PM -
0 Votes
Compare dates in entity query
I think you have to compare days , months and years and dont compare the whole object of the datetime data typeAnswered | 5 Replies | 2443 Views | Created by dcode25 - Thursday, December 22, 2011 2:51 AM | Last reply by AmmatAllah - Sunday, December 25, 2011 12:04 PM -
10 Votes
Compare finish date with target date
But why can it not be as simple as just taking the finish date and compare it with the target date?Answered | 23 Replies | 5742 Views | Created by AT_lamnea - Monday, August 25, 2014 10:20 AM | Last reply by AT_lamnea - Friday, August 29, 2014 5:39 AM -
0 Votes
how compare the date
btw, when you really want to compare the month only, regardless of the year: DECLARE @TextDate1 NVARCHAR(255) = '2012 1' ; DECLARE ...Answered | 3 Replies | 5150 Views | Created by Ranganathan Palanisamy - Thursday, March 10, 2011 10:59 AM | Last reply by eralper - Thursday, March 10, 2011 3:06 PM -
2 Votes
Compare Two Dates
Date1) { MessageBox.Show("Error Please Change the 2nd Date"); }Answered | 3 Replies | 933 Views | Created by IndigoMontoya - Thursday, August 14, 2014 2:58 AM | Last reply by Magnus (MM8) - Thursday, August 14, 2014 9:30 AM -
1 Votes
comparing date variables
The variable ThreeDaysBack in your case would come from a DateTimePicker or TextBox (make sure to validate you have a valid date if coming from a TextBox).Answered | 8 Replies | 1128 Views | Created by Jordan Chan - Wednesday, February 20, 2013 4:10 PM | Last reply by Jordan Chan - Friday, February 22, 2013 2:42 PM -
1 Votes
Comparing dates
The DATE system type is new in SQL Server 2008.Answered | 6 Replies | 4167 Views | Created by dwpeter - Thursday, March 5, 2009 12:46 AM | Last reply by dwpeter - Thursday, March 5, 2009 9:31 PM -
0 Votes
Comparing Dates represented as Strings..
If you cast the variable to compare to datetime, then it would try to implicitly convert character data to datetime also.Answered | 11 Replies | 3928 Views | Created by John Couch - Friday, May 7, 2010 2:11 PM | Last reply by Naomi N - Friday, May 7, 2010 3:17 PM -
0 Votes
Compare date with REST API
Hi, When locale changed to French, the Date Format will be changed to "DD/MM/YYYY hh:mm:ss" like below: And this ...Answered | 3 Replies | 1668 Views | Created by AlexDev62 - Friday, April 6, 2018 8:08 PM | Last reply by Jerry Zy - Monday, April 9, 2018 10:58 AM -
0 Votes
compare with on the date part not the time.............??
but i need the last record of the every person either he has inserted on any date.Answered | 6 Replies | 2655 Views | Created by starnitin - Tuesday, August 14, 2012 7:54 AM | Last reply by starnitin - Tuesday, August 14, 2012 9:11 AM -
2 Votes
compare date without time
Use the Date property of the Date Time, than the time 00:00:00 will be used.Answered | 3 Replies | 7787 Views | Created by naweez - Saturday, November 5, 2011 6:55 AM | Last reply by naweez - Sunday, November 6, 2011 7:33 PM -
0 Votes
Comparing date from postgreaql in c#
= 22.0) { // database date-time is older than 22 hours }Answered | 2 Replies | 4734 Views | Created by xpro6000 - Friday, August 5, 2011 11:03 PM | Last reply by Secure Coder - Saturday, August 6, 2011 5:55 AM -
0 Votes
Modified date compare with othere date column.
Hello Radheshyam Mali, You can't compare two fields by this way.Answered | 2 Replies | 1134 Views | Created by Radheshyam Mali - Friday, April 11, 2014 5:41 AM | Last reply by Radheshyam Mali - Friday, April 11, 2014 6:55 AM -
0 Votes
Conditional Split Comparing Date Value
Now compare them.Answered | 13 Replies | 6377 Views | Created by ansonee - Tuesday, October 25, 2011 4:32 PM | Last reply by ansonee - Wednesday, October 26, 2011 4:43 PM -
3 Votes
Comparing a date to date of end of context filter
this one should work for OpenOrders (your last else-branch): CntOpenOrders:=CALCULATE(COUNTROWS(Requests); FILTER(ALL(Requests[OrderDate]; Requests[DueDate]); Requests[OrderDate] ...Answered | 3 Replies | 4807 Views | Created by Gerrit van Oostveen - Tuesday, July 10, 2012 10:34 PM | Last reply by Gerhard Brueckl - Wednesday, July 18, 2012 9:07 AM -
0 Votes
comparing dates
If so, how can I get that to print if one is null www.helixpoint.com like this declare @prevrequiredDate as date = ...Answered | 5 Replies | 926 Views | Created by Helixpoint - Monday, December 22, 2014 3:46 PM | Last reply by Visakh16 - Monday, December 22, 2014 4:42 PM - Items 1 to 20 of 379161 Next ›
No announcements