Difference between two timeStamp Values


https://www.nevron.com/Forum/Topic4527.aspx 		Print Topic | Close Window

By AlexK - 14 Years Ago

Hello,

I need some help to calculate the difference in days between two Time Stamp Values from the Share Point List.

=Fields!timeStamp2)-Fields!timeStamp1 does not work.

 

thanks
By Nevron Support - 14 Years Ago
Hi AlexK,

Please elaborate on your requirements:

1. What is the structure of your list.
2. Where do you want to show the difference and how (as a label, bar, title etc.)
3. Does your chart has any grouping, filtering sorting requirements etc.
By AlexK - 14 Years Ago

Hi,

The structure of the list (Infopath library):

Projectname (Text)Milestone1 (DateTime)Milestone2 (DateTime)
Example Project09.02.2010 00:00:0002.03.2010 00:00:00
Example Project 225.02.2010 00:00:0015.04.2010 00:00:00

Now I need a Bar Chart:

- The value of the bars should show the difference between Milestone1 and Milestone2 in days for each project.

- No grouping or filtering is required

thank you

Regards, AlexK
By Nevron Support - 14 Years Ago
Hi AlexK,

Generally the chart is created as follows:

1. Create one category data grouping with:

grouping expression: =Fields![RowIndex]
label expression: =Fields!Projectname

This will create a group for each row of the data source and label the group with the project name.

2. Create one values data grouping with:

Value Expression: =TOTALDAYS(Fields!Milestone2 - Fields!Milestone1)

This essenitally creates the chart attached to the post.
The problem is that the subtraction operator for date time variants in the current version is not defined.
This problem will be fixed in the upcomming service pack.

By AlexK - 14 Years Ago

Hi,

can you tell the possible release date for the service pack?

Regards, Alex
By Nevron Support - 14 Years Ago
We expect to have it before the end of next week...