Subject: [xsl] Get the most recent date From: "LEGAULT, PHILLIP plegault@xxxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> Date: Tue, 12 Mar 2024 16:03:32 -0000 |
I have an XML file with the following sections with date fields. I need the latest sf:LastModifiedDate field when sf:ActivityCategory_GCC__c = Additional Information <records xsi:type="sf:Task"> <sf:Id xsi:nil="true"/> <sf:ActivityAwarenessDate_GCC__c>2023-11-05T00:28:00.000Z</sf:Activi tyAwarenessDate_GCC__c> <sf:ActivityCategory_GCC__c>Additional Information</sf:ActivityCategory_GCC__c> <sf:ActivityNumber_GCC__c>xxxxxxx</sf:ActivityNumber_GCC__c> <sf:ActivityType_GCC__c>Receive Phone Call</sf:ActivityType_GCC__c> <sf:DetailsDelayedAwareness_GCC__c>The delay occurred because there was a data-entry omission of "Task" when the follow-up report was created.</sf:DetailsDelayedAwareness_GCC__c> <sf:LastModifiedDate>2023-11-09T04:30:46.000Z</sf:LastModifiedDate> <sf:ReasonDelayedAwareness_GCC__c>Other Cause</sf:ReasonDelayedAwareness_GCC__c> <sf:Subject>Task</sf:Subject> <sf:TranslationCompleted_GCC__c>true</sf:TranslationCompleted_GCC__c > </records> <records xsi:type="sf:Task"> <sf:Id xsi:nil="true"/> <sf:ActivityAwarenessDate_GCC__c>2024-01-23T05:46:01.000Z</sf:Activi tyAwarenessDate_GCC__c> <sf:ActivityCategory_GCC__c>Additional Information</sf:ActivityCategory_GCC__c> <sf:ActivityNumber_GCC__c>xxxxxx</sf:ActivityNumber_GCC__c> <sf:ActivityType_GCC__c>Receive Phone Call</sf:ActivityType_GCC__c> <sf:LastModifiedDate>2024-01-25T13:27:31.000Z</sf:LastModifiedDate> <sf:Subject>Task</sf:Subject> <sf:TranslationCompleted_GCC__c>true</sf:TranslationCompleted_GCC__c > </records> Here is what I have now xslt 2 Receipt Date: <xsl:choose> <xsl:when test="/records/sf:Tasks/records/sf:ActivityCategory_GCC__c = 'Additional Information' and max(/records/sf:Tasks/records/sf:ActivityAwarenessDate_GCC__c)"> <xsl:value-of select="format-dateTime(/records/sf:Tasks/records[sf:ActivityCategory_GCC__c= 'Additional Information']/./sf:ActivityAwarenessDate_GCC__c,'[D01]-[MN,*-3]-[Y0001]')" /> </xsl:when> <xsl:when test="/records/sf:Tasks/records/sf:ActivityCategory_GCC__c = 'Initial'"> <xsl:value-of select="format-dateTime(/records/sf:Tasks/records[sf:ActivityCategory_GCC__c= 'Initial'][1]/./sf:ActivityAwarenessDate_GCC__c,'[D01]-[MN,*-3]-[Y0001]')" /> </xsl:when> </xsl:choose>
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] How to declaratively desc, G. Ken Holman g.ken. | Thread | Re: [xsl] Get the most recent date, Martin Honnen martin |
Re: [xsl] How to declaratively desc, Michael Kay mike@xxx | Date | Re: [xsl] Get the most recent date, Martin Honnen martin |
Month |