I have two fields in a table containing order details, both formatted as standard and containing (M)MYY:

“ConfirmedWEEK”

“DeliveredWEEK”

Suggestions to extract the corresponding date for use in a Pivot Table ?