How to use runtime date/time on workflow formula

AI generated answer (using internal Slack threads):

In NetSuite workflows, when you are dealing with date fields and you want to use a formula, you need to ensure that the result of the formula is in the correct format. From the conversations, it seems like you are trying to add a certain number of days to a date field and then assign this value to another date field. Here is a way to do it: 1. In your workflow, you can use a 'Set Field Value' action. 2. In the 'Value' field, you can use a formula. If you want to add 3 days to the 'Date Created' field, you can use

{datecreated} + 3

. This will add 3 days to the date the record was created. If you are getting an error about the format, you can try to remove the time part from the date. You can use the

RTRIM

function to remove the hours, minutes, and seconds section from the date. The formula would look like this:

RTRIM({today}, ' ')

. If you are still having issues with the format, you can try to convert the result of the formula to a date using the

TO_DATE

function. The formula would look like this:

TO_DATE({today})

. Please note that the

{today}

variable in the formula represents the current date. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******