Formatting a date in Flow

[Mike Dumka]

I know this is crazy, but I using a flow that requires me to update a list with the value of a year. The problem is the users does not want '2018', they only want '18'. Based on the information I have found there is no way to format a date 'YY' ...

Am I losing my mind?

[#2 · Accepted solution]

Hi @Mike Dumka,

You can use a custom date format to achieve this. 

Using Flow's expression builder, select the formatDateTime function, insert in the ( ) the dynamic content token that contains the date from which you wish to extract the year, type a comma after that, and type 'yy' (in single quotes) to pull out the year. This is essentially formatting the date as year only.

Does this help you?

Sandy

[#3]

That was perfect, thank you @Sandy Ussia!