Converting A System Generated Date to Month Year

Retail Experience

I wanted to find out how to convert the date 05/18/21 4:54 PM to May-21

Your assistance is greatly appreciated

Paul Newcome

The most straight forward solution would be to use a nested IF to generate the month and then a RIGHT function to pull the year.

=IF(MONTH([Column Name]@row) = 1, "Jan", IF(MONTH([Column Name]@row) = 2, "Feb", IF(MONTH([Column Name]@row) = 3, "Mar", .............................)))))))))))) + "-" + RIGHT(YEAR([Column name]@row), 2)

Paul Newcome

The most straight forward solution would be to use a nested IF to generate the month and then a RIGHT function to pull the year.

=IF(MONTH([Column Name]@row) = 1, "Jan", IF(MONTH([Column Name]@row) = 2, "Feb", IF(MONTH([Column Name]@row) = 3, "Mar", .............................)))))))))))) + "-" + RIGHT(YEAR([Column name]@row), 2)

Retail Experience

Thank you for the quick response and it freaking worked as expected!!!!!!!!

Awesome,

Mahalo!

Paul Newcome

Happy to help. 👍️