setting date field to null in flow assignment

in assignment elements, flow date fields do not accept globalconstant.empty string, or any values other than a proper date.

i needed to set one to null.

i was able to create a flow formula field, type = date, and value = NULL

and it worked!

nullDateFormula.png

full disclosure - maybe you can just leave it blank in the assignment element. didnt test that! tbd.

 
61
Kudos
 
61
Kudos

Now read this

Evaluating max/min of multiple date fields in flow

UPDATE : JUNE 2023 Summer22 brought us new formula functions. UNIXTIMESTAMP allows you to convert dates to numbers, which can be fed into MAX or MIN, which will return a single value which you can convert back to dates using FROMUNIXTIME... Continue →