Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Ignore #error & Infinity

Topic Labels: Formulas
Solved
Jump to Solution
498 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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’)

1 Solution

Accepted Solutions

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:

See Solution in Thread

2 Replies 2

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:

Thank you so much! that was the solution