No announcements
Found 357167 threads
-
0 VotesCalculated Date
Try this: =TEXT(DATE(YEAR(month),MONTH(month)+1,DAY(month)),"mmmm") It's easy to write and test these if you Excel: ...Answered | 1 Replies | 3428 Views | Created by blnigro - Friday, June 1, 2012 2:01 PM | Last reply by Mike Smith MCT MVP - Friday, June 1, 2012 6:00 PM
-
0 Votes
Date Calculation.
How can these two date give same date on adding -1 month in it.Answered | 3 Replies | 801 Views | Created by Shukla Saurabh - Wednesday, December 18, 2013 11:40 AM | Last reply by Tom Phillips - Wednesday, December 18, 2013 1:54 PM -
0 Votes
Calculate Date
Hello all, I am trying to calculate a Due Date by adding a Date with an integer for example 01/06/10 + 14 = 15/06/10, but i also want to be able to filter ...Answered | 1 Replies | 4323 Views | Created by Supp85 - Monday, June 14, 2010 8:53 AM | Last reply by BernieHunt - Monday, June 14, 2010 12:13 PM -
0 Votes
Calculate a date
If you are trying to achieve in SSRS calculated field, you could try using this express: =DateAdd("d",14,Fields!Answered | 2 Replies | 694 Views | Created by JLL2019 - Wednesday, May 15, 2019 5:35 PM | Last reply by Lukas DreiKlein - Thursday, May 16, 2019 1:37 AM -
0 Votes
Date Calculation
[<your date hierarchy>].CurrentMember,[Dim2].Answered | 1 Replies | 4022 Views | Created by PeaceOut - Friday, July 1, 2011 1:00 AM | Last reply by Boyan Penev - Friday, July 1, 2011 4:04 AM -
0 Votes
Calculated Date Field
Hi Austin- your first and third calculations should work.Answered | 5 Replies | 1435 Views | Created by Austin916 - Sunday, October 16, 2016 6:20 AM | Last reply by croute1 - Tuesday, October 18, 2016 6:16 PM -
0 Votes
Calculated Date Column
You can access a date field's hour using HOUR().Answered | 1 Replies | 1045 Views | Created by Palumbob413 - Friday, February 7, 2014 4:32 PM | Last reply by Philip Greer - Friday, February 7, 2014 7:19 PM -
1 Votes
Calculated member.
Hi Uszkers, If I understanding correctly, there is a datetime column in your datasource, now you want to create calculated member which could extract only year or only ...Answered | 4 Replies | 874 Views | Created by Uszkers - Tuesday, July 15, 2014 8:13 AM | Last reply by Uszkers - Thursday, July 17, 2014 11:42 AM -
0 Votes
Budget Month-to-date calculation
First for calculating days in month.Answered | 7 Replies | 2690 Views | Created by Morten_DK - Wednesday, August 19, 2015 7:14 PM | Last reply by Tomas Ludvik - Monday, August 24, 2015 3:06 PM -
0 Votes
calculate the future date??
Hi yangyeswar, According to your description, you want to calculate the Output value based on the Warranty Initial Period value and Warranty Start Date value, is ...Answered | 1 Replies | 546 Views | Created by yangyeswar - Monday, June 6, 2016 11:30 AM | Last reply by Weiwei Cai - Tuesday, June 7, 2016 9:11 AM -
0 Votes
Calculated Date Field with Truncating
On the same date, in a different place, also a boy was born with the same last name and the same first initial.Answered | 11 Replies | 505 Views | Created by Bill Fry - Tuesday, November 24, 2015 10:44 PM | Last reply by Imb-hb - Tuesday, December 1, 2015 4:36 PM -
1 Votes
calculated date column
LAST DAY OF MONTH =DATE(YEAR(Created),MONTH(Created)+1,0) FIRST DAY OF ...Answered | 2 Replies | 4733 Views | Created by Clardy - Tuesday, March 24, 2009 4:58 PM | Last reply by Clardy - Wednesday, March 25, 2009 12:29 AM -
1 Votes
Sharepoint Calculated Date column
Calculated Field Formulas Another workaround is that we can create an Event Receiver for this, with SharePoint Object Model and other ...Answered | 5 Replies | 3123 Views | Created by Anu L V - Friday, February 14, 2014 1:44 PM | Last reply by R.Mani - Wednesday, February 19, 2014 12:05 PM -
0 Votes
Calculate Date with Exclusions
Have a function called "dbo.udf_addbusinessdays" to add business days to a date.Answered | 4 Replies | 780 Views | Created by Guyatplacedotcom - Wednesday, January 13, 2016 6:38 PM | Last reply by Guyatplacedotcom - Wednesday, January 20, 2016 8:47 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 | 3821 Views | Created by cnsuman - Wednesday, November 25, 2009 4:42 AM | Last reply by cnsuman - Wednesday, November 25, 2009 6:06 AM -
3 Votes
how to calculate the date?
Hi, Try the code below , it will give date after 30 days from now.Answered | 3 Replies | 2759 Views | Created by faisal abdul - Tuesday, January 12, 2010 2:56 PM | Last reply by tushar_sw_archt - Thursday, January 14, 2010 10:42 AM -
0 Votes
DAX Calculate with 2 dates
There's two obvious errors in the DATESBETWEEN function here: first, the first argument must be a reference to the date column in your Calendar or Date table, not a scalar value.Answered | 5 Replies | 1424 Views | Created by fit9 - Monday, January 16, 2017 1:19 PM | Last reply by Michiel Rozema - NL - Wednesday, February 1, 2017 11:26 AM -
1 Votes
InfoPath Date Calculations
This action is initially displayed in a workflow step as Find minutes between date and date (Output to Variable: time).Answered | 2 Replies | 6406 Views | Created by VFNoel - Tuesday, July 26, 2016 6:29 PM | Last reply by Linda ZL - Wednesday, July 27, 2016 3:13 AM -
1 Votes
Calculate AVG on two dates
Hi Faisal, If you trying to use this column in report then you can use Datediff function in report itself instead of calculating in the query, below is the expression to be ...Answered | 7 Replies | 10801 Views | Created by Faisalkyo - Wednesday, November 14, 2012 1:01 PM | Last reply by Faisalkyo - Thursday, November 15, 2012 6:35 AM -
1 Votes
Calculating past and future dates from a static date
Subnet Calculator / Planner Serial PortAnswered | 2 Replies | 3031 Views | Created by JamesLNeal - Tuesday, August 10, 2010 11:22 AM | Last reply by dbasnett - Tuesday, August 10, 2010 1:22 PM - Items 1 to 20 of 357167 Next ›
No announcements
