No announcements
Found 1631590 threads
-
0 VotesDATEDIFF returns wrong value
Datediff counts the number of boundaries passed.Answered | 3 Replies | 2448 Views | Created by Alex Teslin - Wednesday, June 18, 2014 11:28 AM | Last reply by Alex Teslin - Wednesday, June 18, 2014 4:30 PM
-
0 Votes
DateDiff Function to return positive value irrespective of values passed
DateVar2 set @dtVar1 = '2015-01-01' set @dtVar2 = '2015-01-07' -- Query returns 6 select case when datediff( day, @dtVar1, @dtVar2 ) > 0 then ...Answered | 3 Replies | 3335 Views | Created by Mahesh MSBI - Friday, August 7, 2015 4:33 AM | Last reply by Visakh16 - Friday, August 7, 2015 8:31 AM -
0 Votes
Wrong Week DateDiff
The "week" number returned by the datediff function is the number of weeks from Jan 1st of each year.Answered | 3 Replies | 5114 Views | Created by flawell - Monday, October 26, 2009 1:01 PM | Last reply by flawell - Monday, October 26, 2009 9:32 PM -
0 Votes
DATEDIFF return null
By the way, the DateDiff() syntax is: DATEDIFF(interval, datetime, datetime) The "j" interval is ...Answered | 4 Replies | 7238 Views | Created by mabrouko - Thursday, April 26, 2012 12:22 PM | Last reply by Elvis Long - Tuesday, May 1, 2012 7:12 AM -
0 Votes
TSQL Datediff to returns the result with decima
So simple, try the below DATEDIFF(hh, createddate, endeddate )/24.0 as operational_tat, DATEDIFF(hh, receiptdate, endeddate )/24.0 as ...Answered | 6 Replies | 892 Views | Created by Lenoj - Wednesday, July 20, 2016 5:01 AM | Last reply by Harikrishnan-BI - Wednesday, July 20, 2016 6:57 AM -
0 Votes
Filestream.Length returns wrong value??
Mike, Yes, indeed I was reading the wrong file.Answered | 3 Replies | 4370 Views | Created by mihooper1 - Thursday, July 31, 2014 8:38 PM | Last reply by mihooper1 - Friday, August 8, 2014 12:49 PM -
0 Votes
Datediff dateformat yyyymmdd Datediff
DateField1.Value, Fields!Answered | 8 Replies | 7116 Views | Created by Joakim KMT - Wednesday, May 7, 2014 2:07 PM | Last reply by Visakh16 - Friday, May 9, 2014 9:12 AM -
0 Votes
datediff
I think you would also have to use the .MemberValue (provided the attribute has either the KeyColumn or ValueColumn pointing at a date) as otherwise you will be returning ...Answered | 7 Replies | 5951 Views | Created by Sam1980 - Wednesday, November 24, 2010 9:24 PM | Last reply by Vinuthan - Thursday, November 25, 2010 7:37 PM -
0 Votes
Datediff indicator
CFVal3.Value) try this It will return you days...Answered | 5 Replies | 4756 Views | Created by Chris Ba - Monday, April 27, 2009 8:27 PM | Last reply by Sandeep Babbar - Tuesday, April 28, 2009 2:51 PM -
6 Votes
DateDiff function doesn't return correct difference
Hello Amit-Tomar, Can you please explain what is going on with: where DateDiff(yy,birthdate,Convert(varchar(10),getdate(),120))=100 ?Answered | 13 Replies | 1310 Views | Created by cloudsInSky - Thursday, February 22, 2018 5:31 AM | Last reply by Will_Kong - Tuesday, February 27, 2018 8:17 AM -
0 Votes
DATEDIFF - cannot return negatives in Tabular but can in PowerBI?
(https://docs.microsoft.com/en-us/dax/datediff-function-dax#remarks) Best Regards, Will MSDN Community ...Answered | 5 Replies | 2282 Views | Created by OneWithQuestions - Monday, March 18, 2019 6:04 PM | Last reply by Will_Kong - Thursday, March 21, 2019 9:20 AM -
0 Votes
GetLastInputInfo() and GetTickCount() returning wrong values
This used to work correctly but recently on some systems (on those I do not have access), API is returning incorrect value.Answered | 1 Replies | 1278 Views | Created by Mohitskb - Friday, August 5, 2016 6:08 AM | Last reply by Dave Patrick - Friday, August 5, 2016 12:42 PM -
2 Votes
DateDiff
Sure, you can use the CStr() function, to convert any value to a String.Answered | 9 Replies | 4469 Views | Created by S.e.p.y - Thursday, April 7, 2011 9:54 PM | Last reply by Ken Sheridan - Friday, April 8, 2011 6:07 PM -
0 Votes
IIF Value Equals Yes then DATEDIFF and if Value <14 then Met
FIELD1.Value) = "yes", IIF(datediff("d",Fields!Answered | 3 Replies | 6021 Views | Created by iandinpboro - Tuesday, April 19, 2011 8:46 AM | Last reply by Chintak Chhapia - Tuesday, April 19, 2011 9:13 AM -
0 Votes
Conditional DateDiff
It returns #Error and value to add was out of range.Answered | 6 Replies | 1165 Views | Created by Adam-M - Monday, December 15, 2014 11:54 AM | Last reply by Qiuyun Yu - Friday, December 19, 2014 7:20 AM -
0 Votes
MDX DateDiff between quarters
So when you extract the MemberValue by using MDX instead of returning "December 2008" it returns as "12/1/2008".Answered | 4 Replies | 2482 Views | Created by BI Brian - Thursday, December 4, 2014 10:17 PM | Last reply by BI Brian - Monday, December 8, 2014 11:07 PM -
0 Votes
DateDiff
Something like the query below would work, as the 1st axis has a reference for an actual date on each row, and hence the member_value will return the value for that ...Answered | 17 Replies | 5531 Views | Created by Sam1980 - Tuesday, June 28, 2011 5:23 PM | Last reply by Naveen Das - Wednesday, June 29, 2011 2:52 PM -
1 Votes
DateDiff Issue
Declare @sdate datetime = '2014-06-10 17:02:20.170' Declare @edate datetime = '2014-06-10 17:10:23.170' SELECT CONVERT(VARCHAR(6), DATEDIFF(second, @sdate, @edate) / 3600) + ':' + ...Answered | 6 Replies | 1217 Views | Created by Yookos - Tuesday, June 10, 2014 11:11 AM | Last reply by Yookos - Friday, January 16, 2015 2:10 PM -
0 Votes
DATEDIFF calculation
date2.Value,Parameters!Answered | 9 Replies | 3658 Views | Created by mabrouko - Monday, April 30, 2012 11:34 AM | Last reply by Syed Qazafi Anjum - Tuesday, May 1, 2012 10:01 PM - Items 1 to 20 of 1631590 Next ›
No announcements
