Profile Picture

Difference between two timeStamp Values

Posted By AlexK 14 Years Ago
Author
Message
AlexK
Posted 14 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: Forum Members
Last Active: 13 Years Ago
Posts: 8, Visits: 1

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



Nevron Support
Posted 14 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
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



AlexK
Posted 14 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: Forum Members
Last Active: 13 Years Ago
Posts: 8, Visits: 1

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



Nevron Support
Posted 14 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
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



Attachments
AlexK
Posted 14 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: Forum Members
Last Active: 13 Years Ago
Posts: 8, Visits: 1

Hi,

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

Regards, Alex



Nevron Support
Posted 14 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746
We expect to have it before the end of next week...

Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic