dd.mm.yyyy to mm.yyyy

[RDF25087]

Hi all -

I have a data set with the date format of dd.mm.yyyy - for my reporting requirements I only need the data by month not day, so need to convert the date to mm.yyyy. How can I do this please?

Thanks

RDF

[atcodedog05 · Accepted solution]

Hi @RDF25087 

The quickest way is to use right() function like below.

Workflow:

Hope this helps : )

[RDF25087 · Accepted solution]

Thank you @atcodedog05

That seems to work. I just needed to add a DateTime function after your solution to ensure it was in a date format.

RDF

[atcodedog05]

Happy to help : ) @RDF25087 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!