Integromat Search module formula with date lookup field
Hello there,
Please help me out with Integromat Search module.
I used this formula in Integromat Search module to send email 2 days after check out.
Check-out is lookup field.
IF(AND({Rev}!="", { :x: }=BLANK(), DATETIME_DIFF(TODAY(),{Check-out},‘days’)=2),“1”,“0”)
The formula seams to work in airtable, but the search module does not always return correct result.
for ex. same email was sent 2 days in a row, which should not be possible because 2 days difference can be only on one date :confused:
Please advise,
Thank you
