S
sjogran
I have InfoPath#1 form that includes a single Date picker. I have
another InfoPath#2 form that rolls-up (reports) on data in the first
InfoPath form (its a Secondary Data Connection). InfoPath#2 form has
selection criteria and that includes a Start/End Date. So for one field
I track on InfoPath#2 it is a count of how many InfoPath#1 forms were
created within that date range:
count(Working_Prototype[(msxsl:string-compare(StartDate, @Date) <= 0
and msxsl:string-compare(EndDate, @Date) >= 0) and (@ProjectName =
Project or Project = "") and (@ProjectRelease = Release or Release =
"") and (@ReleasePhase = Phase or Phase = "") and (@WorkRequest =
WorkRequest or WorkRequest = "") and (@Team = Team or Team = "") and
(@SubSystem = SubSystem or SubSystem = "")])
Working_Prototype is the name of the form library I'm pulling from.
When I select StartDate = 3/14/06 and EndDate = 3/14/06 there expected
result is 1 (because there is 1 InfoPath#1 form filled out in the form
library. But it will not show 1 until I choose an EndDate of 3/15/06.
It is a problem with EndDate and I do not know why. In my filter data,
I tried separating as 2 separate filters the Start/End dates but this
does not help. Currently, they are both in the same filter as:
StartDate is greater than or equal to Date (InfoPath#1) and EndDate is
less than or equal to Date (InfoPath#1).
Not sure how to resolve this issue but our client does not want any
coding. If anyone knows of a better way to filter or something, let me
know.
another InfoPath#2 form that rolls-up (reports) on data in the first
InfoPath form (its a Secondary Data Connection). InfoPath#2 form has
selection criteria and that includes a Start/End Date. So for one field
I track on InfoPath#2 it is a count of how many InfoPath#1 forms were
created within that date range:
count(Working_Prototype[(msxsl:string-compare(StartDate, @Date) <= 0
and msxsl:string-compare(EndDate, @Date) >= 0) and (@ProjectName =
Project or Project = "") and (@ProjectRelease = Release or Release =
"") and (@ReleasePhase = Phase or Phase = "") and (@WorkRequest =
WorkRequest or WorkRequest = "") and (@Team = Team or Team = "") and
(@SubSystem = SubSystem or SubSystem = "")])
Working_Prototype is the name of the form library I'm pulling from.
When I select StartDate = 3/14/06 and EndDate = 3/14/06 there expected
result is 1 (because there is 1 InfoPath#1 form filled out in the form
library. But it will not show 1 until I choose an EndDate of 3/15/06.
It is a problem with EndDate and I do not know why. In my filter data,
I tried separating as 2 separate filters the Start/End dates but this
does not help. Currently, they are both in the same filter as:
StartDate is greater than or equal to Date (InfoPath#1) and EndDate is
less than or equal to Date (InfoPath#1).
Not sure how to resolve this issue but our client does not want any
coding. If anyone knows of a better way to filter or something, let me
know.