Skip to main content
Developer Communities Admin
Community Manager
September 15, 2026

I am working on XML Pay run data export and want to extract 2 fields which are pay period start date and pay period end date.

  • September 15, 2026
  • 1 reply
  • 0 views

Originally posted by Aman Gaur on July 28, 2026 at 1:27 AM.

 

Hello community,

 

I am working on XML Pay run data export and want to extract 2 fields which are pay period start date and pay period end date. Tried multiple tokens from pay run data export guide but unable to find correct one.

Also tried below token but not working:

payrun_period_start_date

payrun_period_end_date

 

Can anyone help me with this one?

 

<Column Name="Payperiod_StartDate" DataType="DateTime" Source="Data" Value="payrun_period_start_date"/>

<Column Name="Payperiod_EndDate" DataType="DateTime" Source="Data" Value="payrun_period_end_date"/>

 

Thanks, in advance.

    1 reply

    Developer Communities Admin
    Community Manager
    September 15, 2026

    Originally replied by Frank Ruffolo on Jul 28, 2026, 12:09 PM.

     

    Hey @Aman Gaur​ I've used these in the past with success:

     

    <Column Name="PayDate" DataType="datetime" Source="data" Value="payperiod_paydate" />

    <Column Name="PayStarting" DataType="datetime" Source="data" Value="paygroup_periodstart"/>

    <Column Name="PayEnding" DataType="datetime" Source="data" Value="paygroup_periodend"/>

    <Column Name="PayPeriod" DataType="string" Source="data" Value="payperiod_ppn" />

    <Column Name="PaySuffix" DataType="string" Source="data" Value="payperiod_suffix" />

    <Column Name="PayPeriodWSuffix" DataType="string" Source="data" Value="payperiod_ppnwithsuffix" />