Converting Text column with fiscal periods to a date

Hello,

I have a relatively simple dataset with one column that lists fiscal periods, another with some product types, and another with sums of those product types.

I'd like to use this data to create a bar variance card, but Domo is currently looking at my fiscal periods column like they're 'text' instead of 'dates.' The periods are formatted like FY22P5, FY22P6, etc.

How would I convert the data column so that it's being looked at as a date as opposed to a string of text?

Answers