I'm trying to add a number of days from a free form text field to a date field via a workflow. {date} + 30 doesn't seem to be working properly. Is there a certain way I have to format it?
n
Netsuite Tragic
03/13/2021, 8:15 AM
@Brian try wrapping your values TO_CHAR({date},’MM/DD/YYYY’) + TO_NUMBER({yournumber}).
t
Tristan Day
03/13/2021, 10:26 AM
is the date field you're sourcing from in a join? NS workflows hate those, you need to create a workflow field to source it in to first, then do the transformation