Intck

[HeatherNewton]

I have a condition

Where intck(‘month’, transaction_post_date, “&sampdate.”D)=0;

What does it mean?

[HeatherNewton]

Is it equal to the condition
Where transaction_post_date>=intnx(“month”,”&sampdate.”d,-12,”B”)
?

[Kurt_Bremser]

No. When the result of INTCK is 0, it means that both dates are within the same interval. Your condition would also validate all dates after the month.

Study the documentation of the INTCK Function 

Edit: fixed a typo

[HeatherNewton]

What if I add one more line to Code A

Code A is as follows:

Where trasaction_post_date >=intnx(“month”,”&sampdate.”d,-12,”B”)
And transaction_post_date<=“&sampdate.”d

If today is sampdate, trasaction_post_date in code A refers to dates from 1st Oct 2021

Code B is as follows:
Where intck(‘month’,’transaction_post_date,”&sampdate.”d)=0;

If today is sampdate, transaction_post_date in Code B refers to any dates within Oct 2022...

Is my interpretation above correct?

[Kurt_Bremser]

These conditions would only be equivalent if &sampdate was the last day of the month.