
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2020 02:41 PM
Hello,
I have a field that based on a closing date of a sale, converts the closing date to the ‘dddd’ so as i can see which day of the week i sell most. If I have not closed the status of a product it shows #error in the value. I’d like tobe empty.
DATETIME_FORMAT({Closed Date},‘dddd’)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2020 02:58 PM
Welcome to the community, @Nikos_Gaz!
Change your formula to this:
IF({Closed Date},DATETIME_FORMAT({Closed Date},‘dddd’))
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2020 02:58 PM
Welcome to the community, @Nikos_Gaz!
Change your formula to this:
IF({Closed Date},DATETIME_FORMAT({Closed Date},‘dddd’))
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 02, 2020 03:01 PM
Thank you so much! that was the solution
