Extract Date from Report Metadata to Use As a Field

[WappySprayberry]

Hello,

I'm looking to see if it's possible to extract dates from the metadata of a report to use as a field. The report names and fields within the reports don't have dates from which to borrow, and I'll need to have dates as the first field from which to summarize data (with the second field being state and third field being amount). Certain tools allow you to see the creation, access, and last write time, and I'm hoping to be able to pull the creation date in the metadata as a field in the output. Further, I need to take that date and turn it into a specific "Mmmmmm YYYY" format. For example, if the creation date of the report was 01-23-2022 then I would want to change the date to be January 2022. I placed a screenshot below of what my output would look like before and after.

Thank you,

Jason

[Qiu · Accepted solution]

@WappySprayberry 
It will better you can provide a sample input.

As for the Date format, we can use the function "DateTimeFormat" as below

[WappySprayberry]

Thank you!