Date formula not working correctly
So I have the following formula
=IF(AND(GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")
And my result is showing # Unparsable.
What is wrong with my formula these are date columns.
Thank you
Best Answer
-
Hey @Buster Davis
Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?
I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Missing a bracket in front of GO.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
You are missing a bracket on the GO Live Date reference.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")
Hope this helps!
-
With the correction of the missing bracket, now I am getting invalid operation? Thoughts
-
Hey @Buster Davis
Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?
I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you your formula worked perfectly..
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!