could you please attach a sample workbook to help you further
Ensure that your date is a string data type, then use the following calculated field.
// Parse the string then create an actual date.
MAKEDATE(INT(LEFT([Date],4)), INT(RIGHT([Date],2)), 1)
Then, after you drag it to your view, format it using a custom date format of mmm yy.
String to Date.twbx 29.8 KB
You are a life saver, thanks a ton!
Thank you for the response. The below solution by Ken worked for me.