how to show the month in names not <2024-06> in sa...
# ask-stanley-ai
h
how to show the month in names not 2024-06 in saved search
c
AI generated answer (using internal Slack threads):
To show the month in names and not in the format
2024-06
in a saved search, you can use a formula field in your saved search. Here are the steps to do it: 1. Go to your saved search and click on the
Results
subtab. 2. Click on
New Field
and select
Formula (Text)
as the type. 3. In the
Formula
field, enter the following formula:
TO_CHAR({trandate}, 'Month')
. This formula will convert the date into the month name. 4. In the
Summary Type
, select
Group
. 5. In the
Label
field, enter a name for this field, for example,
Month Name
. 6. Click
Save
. Now, when you run the saved search, you will see the month names instead of the date format
2024-06
. Please note that this solution assumes that you are using the
trandate
field in your saved search. If you are using a different date field, replace
{trandate}
with your date field in the formula. ****** 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.85025239
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839523
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839277327
Please provide your feedback on this answer.