You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel template

Accepted answer
6
Views
1
Comments
edited Jul 26, 2021 2:05PM in Reporting and Analytics for HCM 1 comment

Summary

Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel template

Content

Hi experts, I have an excel template ( from a benefits extract) in BI Publisher &  I need to find the maximum between

<CI_Ori_Enrol_Date>2023-09-01T00:00:00.000Z</CI_Ori_Enrol_Date>
<A_Ori_Enrol_Date>2020-10-01T00:00:00.000Z</A_Ori_Enrol_Date>


<xsl:variable name="a" select="Emp_Enrol_Acc_T_Rec/Emp_Enrol_Acc_DG/Emp_Enrol_Acc_Rec/A_Ori_Enrol_Date"/>
<xsl:variable name="b" select="(Emp_Enrol_CI_T_Rec/Emp_Enrol_CI_DG/Emp_Enrol_CI_Rec/CI_Ori_Enrol_Date)[1]"/> 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!