Convert TImeDate field to output Year & Month

[Anonymous]

Hello Community

Issue

I have a Created column coming in from a SharePoint list and it displays as time and date. I would like to create a custom column that will display 2018 for all dates within 2018 and also another column to display month if possible.

05/08/2015 13:41:19 would ideally become 2015 for example. I'd then like to add a Year slicer to my visual.

I would very much appreciated if someone could help me with this.

Thanks, M

[Matt_Alexander · Accepted solution]

Hi @Anonymous,

I would duplicate the column and then on each one use the built in functions in Edit Queries to extract what you want, month, year etc in each copy of the original column. 

Hope that helps!

Matt

[Anonymous]

Thank you very much for this. It worked perfectly.

Easy when you know how 🙂

[PattemManohar]

@Anonymous Are you looking for YEAR and MONTH functions to extract year and month values from the Date Time field ?