hi again ! I’m trying to auto populate a date fiel...
# suiteflow
l
hi again ! I’m trying to auto populate a date field from a workflow (After field edit). It works fine on the record creation with the following formula: to_date({customdatefield} - 3 ) But when I try to o the same in "After field edit" action, I obtain NaN value.
k
Looks like you have it working on server-side triggers but it doesn't work on client-side triggers: I think you'll need to write the formula in SuiteScript instead of SQL
l
Thanks for taking some time to answes. So I would need to use the nlapi functions in order to retrieve the date ? Is that what you mean ?
k
I'm not an expert, but yes. From Suiteflow documentation:
l
Thanks !