You could use the DayName() function instead. Or simply format the date field itself to display only the day name - no calculation field required.
I am trying to create a weekly sales report from 4 diferrent places, it is very easy to make one on excel but have not been able to make one on Bento,
my report has to have sales report from all 4 places everyday of the week.
Thank you for your post.
I see this is your first post to the forum. Since you mentioned "Bento", you may want to post your question on the Bento forum at:
If you are using FileMaker Pro, then explain a bit more "from 4 different places". What are the places?