Hi everyone, Currently I save this value

{"terms":"40":[{"seqnum":1,"amount":2328.48,"duedate":"2024-02-02"}]}

on custom field within the vendor bill. Is it possible to use any formula in a custom field to save just this value

2024-02-02

?

Don’t understand you have {"terms":"40":[{"seqnum":1,"amount":2328.48,"duedate":"2024-02-02"}]} in custom field ?? If you want juste 2024-02-02 use SUBSTR({customfield}, INSTR({customfield}, '"duedate":"') + 10, 10)