No announcements
Found 1849447 threads
-
2 VotesMDX selection between start date and end dates
Hi karthi, well, regarding performance you could try partitioning your measure group (SSAS Enterprise Edition only).Answered | 3 Replies | 1920 Views | Created by karthi20 - Sunday, March 29, 2015 3:25 PM | Last reply by Martin Guth - Friday, April 10, 2015 7:23 AM
-
5 Votes
Show calculated date column as null when there is no date
a Date-only Calculated Field in SharePoint with "NA" or "" or " " would work fine / appears fine in SP Front End.Answered | 13 Replies | 76310 Views | Created by bootzilla - Saturday, December 17, 2011 3:44 PM | Last reply by Siva Balan (SKB) - Tuesday, February 2, 2016 7:49 AM -
0 Votes
Date Calculations
So if you have the start date in B1, you could use: =DATE(YEAR(B1), 5, 31)-B1Answered | 2 Replies | 683 Views | Created by rmindas - Friday, August 28, 2015 7:31 PM | Last reply by Scooterza - Friday, August 28, 2015 8:44 PM -
0 Votes
Calculate XIRR in T-Sql
Perfectly matching with Excel calculation.Answered | 6 Replies | 17594 Views | Created by Maulik A. Dusara - Friday, August 6, 2010 7:43 AM | Last reply by Anil Nagthane - Tuesday, July 9, 2019 9:50 AM -
3 Votes
Calculating Date Difference
After removing the conversion, I'm now able to calculate the DATEDIFF where the date is not NULL and is not blank.Answered | 10 Replies | 1128 Views | Created by Seif Orabi - Thursday, April 16, 2015 5:35 AM | Last reply by Seif Orabi - Wednesday, April 22, 2015 8:15 AM -
9 Votes
calculate number of months,weeks,days for two dates
JR1811, Can you kindly explain how the difference is calculated .Answered | 23 Replies | 12072 Views | Created by JR1811 - Wednesday, August 15, 2012 6:02 PM | Last reply by JR1811 - Thursday, August 16, 2012 9:04 PM -
2 Votes
How to change date to End of Day?
I did not mean that inequalties optimze better than between in MS SQL Server.Answered | 12 Replies | 36986 Views | Created by Mantros Group - Friday, September 3, 2010 1:12 PM | Last reply by Mantros Group - Friday, September 3, 2010 3:10 PM -
0 Votes
Need to CALCULATE Subscription Retention with Start and End Dates
I have defined the following calculations on the 'Subscription' table: ...Answered | 4 Replies | 1802 Views | Created by kathrynsharepoint - Tuesday, October 15, 2013 10:57 AM | Last reply by kathrynsharepoint - Friday, October 25, 2013 5:41 PM -
0 Votes
Calculate the working hours between 2 date/times.
I went through everything and there are the same number of ends as there are begins so I'm at a loss on this again.Answered | 4 Replies | 3436 Views | Created by msegars - Tuesday, December 10, 2013 2:17 PM | Last reply by msegars - Wednesday, December 11, 2013 9:27 PM -
0 Votes
calculate fiscal year from date
> How do I calculate Fiscal year from a date, my fiscal year starts from July 01.Answered | 3 Replies | 12730 Views | Created by SQL_Gun - Monday, December 17, 2012 7:04 PM | Last reply by --CELKO-- - Monday, December 17, 2012 11:22 PM -
2 Votes
Help calculating count prior to header date
If table EOM has a column with dates, and that column is linked to table DATA, how would I adjust that formula to calculate?Answered | 3 Replies | 1016 Views | Created by avalerion - Friday, November 13, 2015 6:12 PM | Last reply by greggyb - Friday, November 13, 2015 8:48 PM -
0 Votes
date comparision and calculating
The first solution involves calculating the distance (in days - if you have a finer granularity, you may want to use hours or minutes or seconds) between the parameter and ...Answered | 2 Replies | 4039 Views | Created by cnsuman - Wednesday, November 25, 2009 4:42 AM | Last reply by cnsuman - Wednesday, November 25, 2009 6:06 AM -
0 Votes
Calculate Second Difference in SQL Server dates
Obviously you can calculate what those second-values should be, but it will always be hard to read and debug.Answered | 4 Replies | 1534 Views | Created by Manjunath C Bhat - Thursday, February 7, 2013 11:01 AM | Last reply by Manjunath C Bhat - Friday, February 8, 2013 1:00 PM -
0 Votes
Week Start Date and End Date
You can calculate this value without relying on DATEFIRST.Answered | 6 Replies | 1027 Views | Created by srinivas_ch - Monday, May 4, 2020 10:02 AM | Last reply by Jeff Williams 3188 - Monday, May 4, 2020 7:08 PM -
0 Votes
How to calculate campdate > todays date + 45 days in sql query
CAST(dateadd(day,45,GETDATE()) AS DATE) THEN 'Y' ELSE 'N' END Allen Li TechNet Community SupportAnswered | 3 Replies | 2200 Views | Created by Simran08 - Tuesday, October 23, 2012 1:10 PM | Last reply by Allen Li - MSFT - Monday, October 29, 2012 10:13 AM -
1 Votes
Calculating duration from start date to end date (DateTime)
=24 then 1 else 0 end from @t Thanks and regards, Rishabh , Microsoft Community ContributorAnswered | 7 Replies | 3248 Views | Created by Sam233 - Friday, September 2, 2011 8:48 AM | Last reply by Christa Kurschat - Friday, September 2, 2011 12:55 PM -
0 Votes
How do I compute a list of work dates based on a start and end date?
If you have any question, feel free to let me know.Answered | 3 Replies | 730 Views | Created by Debbie Erickson - Monday, February 15, 2016 10:26 PM | Last reply by Debbie Erickson - Tuesday, February 16, 2016 3:07 PM -
0 Votes
in stored proc should we use begin end or not.
One scenario where you have to use begin..end is as Sambath said, If Else statement.Answered | 4 Replies | 2423 Views | Created by rajemessage - Thursday, June 21, 2012 7:15 AM | Last reply by Shailesh Thapliyal - Thursday, June 21, 2012 8:27 AM -
0 Votes
Calculating age with date function
There are some good articles / solutions on how to calculate a person's age (for example this ...Answered | 5 Replies | 4261 Views | Created by Kenny_Gua - Friday, September 2, 2011 2:57 PM | Last reply by Gert-Jan Strik - Sunday, September 4, 2011 4:36 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]); ...Answered | 3 Replies | 4938 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
No announcements
