I have a simple workflow question, I can't figure ...
# generalt
Thorshanda
03/06/2023, 4:28 PMI have a simple workflow question, I can't figure out how to subtract dates from the startdate. I'm very new to workflows in NS, and trying to get this sorted out. Trying to see if anyone has done this before and can tell me what I'm missing/doing wrong.
Thorshanda
03/06/2023, 4:32 PMThis is what I currently have the one marked in red is the one that isn't working. I had it written as {startdate} - 3 and that still didn't update the field
a
AI1
03/06/2023, 4:37 PMCan you send a screenshot of the state parameters not this summary view. Your parameters aren’t making sense
t
Thorshanda
03/06/2023, 4:38 PMSure give me just a bit, I started to rebuild it just in case I missed something silly.
a
AI1
03/06/2023, 4:40 PMI don’t think your parameter should have the = {custbody_donotshipbefore} in it. Try taking that out
Should just be {startdate} - 3
t
Thorshanda
03/06/2023, 5:47 PMthat's what I had originally, and it still didn't work. I'm having wifi issues due to a recent store. I'll try that again and circle back
t
Tristan Day
03/06/2023, 5:52 PMtry wrapping it in TO_DATE
a
AI1
03/06/2023, 10:48 PMAre you getting a date format error?
AI1
03/06/2023, 10:55 PMIf so since your do not ship after date = start date then try the formula using the do not ship after date instead of startdate
Sometimes you can use simple subtraction with custom fields but cannot do the same simple subtraction using native fields
So Do not Ship Before = {custbody_donotshipafter} - 3
3 Views