IS_BEFORE not working but NOT(IS_AFTER) works___??

[taybulls]

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

[kuovonne]

Could the dates be the same value?

Could there be a hidden time component?

Screen captures?

[taybulls]

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

 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]

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

The date to compare is 10.3.2023 but the formulas disagree

[kuovonne · Accepted solution]

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

[taybulls · Accepted solution]

Wow, that is embarrassing.

Thank you for seeing that.

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

[kuovonne]

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.