Skip to main content
Topics#FlowBaird Straughan 的问题
Baird Straughan 提问于 #Flow
2023年6月1日 19:50

Add 365 days to the CloseDate value for a custom date field in Flow.

I have a Flow to do some field updates on Oppty records. Everything works except an update to a date field.  The gist is I need a date field to be set to one year past the CloseDate value.  I can do this in a formula field or workflow field update with the simple formula CloseDate + 365 (leap years don't need to be addressed in this case).  It works fine in Workflows, but because of the specifics of this process and the order of operations (that workflows are fired before Flows), I need this to happen in my Flow.

But Flow won't accept adding 365 to a date field as a valid date result.  When I try {!$Record.CloseDate + 365} or {!$Record.CloseDate} + 365 I get the error: "We don't recognize that value. Make sure it's a valid date in this format: M/d/yyyy." 

So first, why wouldn't Flow accept a formula that works elsewhere, and second, can someone point me to a solution?  I tried variations on this like re-configuring the date with a DATE function and then stripping out the month, day and year and increasing the year by one, but that also did not work.  I also tried storing CloseDate as a Flow variable and operating on that, but that approach did not work. 

I've run out of ideas.  Thank you all for any help!  I would love to know why the simple formula field didn't work if anyone is willing to explain.
1 个回答
  1. Baird Straughan
    2023年6月2日 15:41
    OK, I figured this out on my own after many hours of working on it.  It turns out that in Flow you can't operate on a field update using a formula.  What I had to do was add a new "Formula" resource in the flow, perform the formula (CloseDate+365) on THAT resource, and then use that formula resource for the field update.  Et voilla!  It works!
撰写回答...
0/9000