I've been stumped on this problem for 2 days and any help would be VERY appreciated.
I have a list that I had to use strings instead of date fields for to comply with a legacy system. I need to compare those dates to todays date to pull numeric values for a field named 'Current' when the date is less than the current date. In order to make
these dates comparable, I linked to another data source that is a conversion table that contains a column with each of the strings and another column with the actual date value for that string. I used the following lines of code to do that conversion:
<xsl:variable name="Datevar" select="@planDateVar"/>
<xsl:variable name="Date" select="/dsQueryResponse/Rows/Row[@Title=$Datevar]/@ConvDate"/>
When I attempt to pull the value for current using the variable "Date", it seems to be only comparing the first value where the other paramaters are true then summing the rest regardless of the date comparison. If the first value of @planDateVar in the list
is less than today's date, it will sum all of the rows where the rest of the parameters are true. If the first value of @planDateVar in the list is greater than today's date, it will sum to 0.
I think that if I could get the variable $Date to pull for each corresponding row in the PlanD
View Complete Post