Help

IS_BEFORE not working but NOT(IS_AFTER) works___??

Topic Labels: Formulas
Solved
Jump to Solution
1348 6
cancel
Showing results for 
Search instead for 
Did you mean: 
taybulls
5 - Automation Enthusiast
5 - Automation Enthusiast

Why would

IF(NOT( IS_AFTER( Date,'10/4/2023)
function correctly and
IF(IS_BEFORE(Date,'10/4/2023)
not function the same in a formula

is not after = is before

 

2 Solutions

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

You are showing the field {invoice_issue_date_rollup} in your screenshots, but you are using {invoice_purchase_date_rolllup} in your formulas.

 

See Solution in Thread

taybulls
5 - Automation Enthusiast
5 - Automation Enthusiast

Wow, that is embarrassing.

Thank you for seeing that.

Any way to just delete this entire thread from the community hahaha, 

See Solution in Thread

6 Replies 6

Could the dates be the same value?

Could there be a hidden time component?

Screen captures?

taybulls
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for reaching out.

There is a hard coded date in the formula of '9/22/2023'

I have both versions of the formula below and the other date that is being called into question:

- If the date in question (invoice_purchase_date_rollup) pre-dates the hard coded date of '9/22/2023' it should display 'PRE-DATES'

I named the columns with which formula I'm testing:

is_before_formula

IF(
  IS_BEFORE(invoice_purchase_date_rollup,'9/22/2023'),'PRE-DATES','CHECK THOSE MINS')
 
not_is_after_formula
IF(
  NOT(IS_AFTER(invoice_purchase_date_rollup,'9/22/2023')),'PRE-DATES','after')
 
Screenshot 2023-10-04 at 4.09.19 PM.png
 As you can see the 19th & 20th do not show the same answer.
IS_Before is displaying that the date comes after 9.22.23
while the other
NOT(IS_After) is displaying PRE-DATES as expected

I'm confused because they are basically asking the same thing but only one is functioning properly.
Correct?

thanks again for reaching out
taybulls
5 - Automation Enthusiast
5 - Automation Enthusiast

Forgot to include the one that started me down this rabbit hole.

The date to compare is 10.3.2023 but the formulas disagree

taybulls_0-1696450789796.png

 

kuovonne
18 - Pluto
18 - Pluto

You are showing the field {invoice_issue_date_rollup} in your screenshots, but you are using {invoice_purchase_date_rolllup} in your formulas.

 

taybulls
5 - Automation Enthusiast
5 - Automation Enthusiast

Wow, that is embarrassing.

Thank you for seeing that.

Any way to just delete this entire thread from the community hahaha, 

No worries. It actually is better for the community as a whole if the thread stays. It helps other people realize that (1) posting screenshots is really helpful in getting answers, and (2) checking the fields you use is important. You would probably be surprised how often people are reluctant to do either of those things.