+ Start a Discussion

Use of Date Fields in Formulas within Flow

I am using Flow.


I have used dates within formulas.


These work great in the Designer version.


However, when you try to upload it, it comes up with an error message saying you can't reference a date within a Formula.


Has anyone else experienced this problem? Does anyone know of a fix?


Otherwise the only workaround I can think of is to write the data back to SFC and read back a formulated field from there but it doesnt seem particularly efficient.


Try using the functions given below :


          DATEVALUE(expression) function creates a date from its datetime or text representation.

          DATE(year,month,day) -> Creates a date from a year, month and day.

          DAY(date) -> Returns the day of the month, a number between 1 and 31.