Turning an integer value into a date field

[HarveyB-B]

Breakdown of the solution:

Max date for each accountingperiod

I then formatted this as an actual date (concat to include ‘/’ between YYYY/MM/DD)

I then parsed this field as a date: