oliroe
Occasional Member - Level 1

Date attributes for credit card data

Hi

I'm trying to create a pivot report based on credit card transactions but need the month number and year number. Several of the dates provide the attributes in order to do this but none of the credit card dates do (as shown below)

Is there anyway to retrieve the month and year number from the credit card date types?

oliroe_0-1623070134962.png

oliroe_1 - 1623070162884. - png