Forum Discussion

Mike Dumka's avatar
Mike Dumka
Iron Contributor
Apr 13, 2018
Solved

Formatting a date in Flow

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?

Microsoft Flow
sharepoint
  • Sandy Ussia's avatar
    Sandy Ussia
    Apr 17, 2018

    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

     

2 Replies

  • Sandy Ussia's avatar
    Sandy Ussia
    MVP
    Apr 17, 2018

    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

     

Resources