The problem we need to solve: * The date we want in this field is the Pay Period End Date * If the record is an Accrual though, we want the Fiscal Period End date * If the record is an Accrual Reversal, we want the Fiscal Period Start date We can determine if the record being processed is an Accrual or not, by looking at the [Journal Source|JOURNAL_SOURCE] field. The values of interest are "03" for Accrual and "06" for Accrual Reversal. So, writing this in ''pseudo code'' we would see something like this: {{{ DECODE(journal_source, '03',fiscal_end, '06',fiscal_start, pay_period_end) -- The "Else" condition }}} using the [substr|SUBSTR] function, we can extract the pieces that we need from GL Buffer as such: {{{ decode(subtr(~,17,2), '03',substr(~,40,11), '06',substr(~,29,11), substr(~,160,11)) }}} ---- ![Notes|Edit:Internal.GL BUFFER EXAMPLE 03] [{InsertPage page='Internal.GL BUFFER EXAMPLE 03' default='Click to create a new notes page'}]