Format a date in a Flow

dateformulavisual-workflow

I used in my flow a custom field of type date which returns to me in the email action a value of the date in the form of month Daye , Yers , what I want is to have the value of the date in the form DD/MM/YY , I created a formula type resource and I added in date type "date" and in the formula my custom field , but I still have the same display
enter image description here

Best Answer

Try taking a date variable in the flow. Now Suppose your variable is originalDate.

Your formula will be for storing date as MM-DD-YYYY will be -

TEXT(MONTH(originalDate))+ "-" + TEXT(DAY(originalDate))+ "-" + TEXT(YEAR(originalDate))

Play around this to get your desired result.

PS: Formula field will be of the type text and showing date as text on flow will be easier, for storing it to salesforce use the same originalDate field.

Related Topic