+ Start a Discussion
Silkcutz01Silkcutz01 

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.

Pradeep_NavatarPradeep_Navatar

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.