formula to get the date from a workflow in a saved...
# ask-stanley-ai
s
formula to get the date from a workflow in a saved search
c
AI generated answer (using internal Slack threads):
To get the date from a workflow in a saved search, you can use the
{workflow.currentDate}
field in your formula. This field will return the current date of the workflow. However, please note that this field will only return the date when the workflow is currently running. If the workflow is not running, this field will return null. Here is an example of how you can use this field in a formula:
Copy code
sql
CASE WHEN {workflow.currentDate} IS NOT NULL THEN {workflow.currentDate} ELSE {today} END
In this formula, if the workflow is currently running, it will return the current date of the workflow. If the workflow is not running, it will return today's 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. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833659291
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.833584189
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832674861
Please provide your feedback on this answer.