Vedachalam Mahadevan
04/01/2025, 5:54 AMCeligo AI
04/01/2025, 5:54 AMAI generated answer (using internal Slack threads):Based on the conversations provided, there is no direct mention of an equivalent
calendarWeek
SuiteAnalytics column. However, there is a suggestion to use the to_char
function to isolate data for 'this week' in a saved search. The formula provided is to_char({today}, 'ww') == to_char({datefield}, 'ww')
. This formula compares the week number of the current date ({today}
) with the week number of the date field ({datefield}
) in question. If they match, it means the date field falls within the current week.
******
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
04/01/2025, 5:55 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.807582259
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.801923752
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.79909271
Celigo AI
04/01/2025, 5:55 AM