Excel Report: Change Field Data Format into Month and Year

[neromerob]

Hello to everyone.

I´m working in a workflow in which I have a field that shows Date, I use a formula just to extract just the month.

In my monthly report the result is shown like this

But I need a formula or a way to change the fields to something like this

Consider that this report must show the new month and the year.

Can you help me with a way to achieve just that?

Thank you

[binuacs · Accepted solution]

@neromerob this can be achieved by using the dynamic rename tool. Attaching a sample workflow for your reference

[neromerob]

Hello.

First of all thank you for this option, I think I need to explain more about my situation.

My report is going to have 2 sheet.

One sheet with information like this.

Mont                                 count

2021-03-01 00:00:00       488

And the other one is a cross in which month becomes a column with the number where the count “comes from”

Name            Lastname           2021-03-01 00:00:00

Nelson           Romero                          48

Robert           Smith                              440

This information comes from a database that every month changes.

So I´m looking for a way that when I turn this into an Alteryx app, automatically will change the months in the future. Meaning that if I want to run the future app in November won’t show me 2021-11-01 00:00:00.

From this

Sheet One.

Mont                                 count

2021-03-01 00:00:00       488

.

.

.

2021-11-01 00:00:00.     500

Sheet two

Name            Lastname           2021-03-01 00:00:00           2021-11-01 00:00:00

Nelson           Romero                          48                                             300

Robert           Smith                              440                                            200

To this

Sheet One.

Mont                                 count

March 2021                        488

.

.

.

November                          500

Sheet two

Name            Lastname           March-2021            ……….          November-2021

Nelson           Romero                          48                                             300

Robert           Smith                              440                                            200

Thank you.