I have a simple base that shows transactions each month and allows me to track date of the transaction.
I want to add a formula field that will compare Entered date (year & month) to the current year and month:
IF(
AND(
IS_SAME({Entered},TODAY(),'year'),
IS_SAME({Entered},TODAY(),'month'),1,0
)
)
This isn't returning any values in the formula field though. If I just use one of the IF statements for either year or month, it works fine. It's when I try using AND that returns nothing. Any suggestions?
