Hello, I am trying to add a column of data to a recipe of mine in CRMA. I would like to display the day of the week (Monday, Tuesday, etc.) based on the created date of a task. So for example, if the "created date" of a task is 4/11/25, then a new column of data generated in this recipe will show a value of "Friday". I was able to achieve tasks and events report, but sadly the report does not give me enough other information. Any help woudl be appreciated!
I found the answer! CRMA uses a different formula for the same function, it is "dayofweek" instead of "weekday". Posting here in case it ever helps anyone else searching the forums. This formula created a column labeling the days 1-7. I then had to convert this new column from number to text using a different formula, and finally relabel these values (ex. change 1 to "1. Sunday", 2 to "2. Monday", etc.)
