Mayesh Nadesan
03/14/2025, 6:07 AMCeligo AI
03/14/2025, 6:08 AMAI generated answer (using internal Slack threads):In order to display the creation date in a saved search in the format dd-mmm-yyyy, you can use a formula text field with the SQL function TO_CHAR. Here are the steps to do this: 1. In your saved search, go to the Results tab. 2. Click on the 'New Field' button. 3. In the pop-up window, select 'Formula (Text)' as the type. 4. In the formula field, enter the following SQL function:
TO_CHAR({createddate},'DD-MON-YYYY')
. This function will convert the 'createddate' field into the desired format.
5. In the 'Summary Type' dropdown, select 'Group'.
6. In the 'Label' field, enter a name for this new field, for example 'Creation Date'.
7. Click on the 'OK' button to save the new field.
Now, when you run the saved search, the creation date will be displayed in the format dd-mmm-yyyy.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
03/14/2025, 6:08 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.832889616
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.828402221
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.82476294
Celigo AI
03/14/2025, 6:08 AM