IS_BEFORE not working but NOT(IS_AFTER) works___??

Could the dates be the same value?

Could there be a hidden time component?

Screen captures?

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

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

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

The date to compare is 10.3.2023 but the formulas disagree

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.