No announcements

### Calculated Date

Try this: =TEXT(DATE(YEAR(month),MONTH(month)+1,DAY(month)),"mmmm") It's easy to write and test these if you Excel: ...
| 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

### Date Calculation.

How can these two date give same date on adding -1 month in it.
| 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

### 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 ...
| 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

### Calculate a date

If you are trying to achieve in SSRS calculated field, you could try using this express: =DateAdd("d",14,Fields!
| 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

### Date Calculation

| 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

### Calculated Date Field

Hi Austin- your first and third calculations should work.
| 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

### Calculated Date Column

You can access a date field's hour using HOUR().
| 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

### 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 ...
| 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

### Budget Month-to-date calculation

First for calculating days in month.
| 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

### 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 ...
| 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

### 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.
| 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

### calculated date column

LAST DAY OF MONTH =DATE(YEAR(Created),MONTH(Created)+1,0) FIRST DAY OF ...
| 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

### 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 ...
| 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

### Calculate Date with Exclusions

| 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

### 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 ...
| 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

### how to calculate the date?

Hi, Try the code below , it will give date after 30 days from now.
| 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

### 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.
| 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

### InfoPath Date Calculations

This action is initially displayed in a workflow step as Find minutes between date and date (Output to Variable: time).
| 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