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

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.

Best Regards,
Nevron Support Team

Hi,

The structure of the list (Infopath library):

Projectname (Text)	Milestone1 (DateTime)	Milestone2 (DateTime)
Example Project	09.02.2010 00:00:00	02.03.2010 00:00:00
Example Project 2	25.02.2010 00:00:00	15.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

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.

Best Regards,
Nevron Support Team

Hi,

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

Regards, Alex

We expect to have it before the end of next week...

Best Regards,
Nevron Support Team