Help

AND condition help

Topic Labels: Formulas
185 1
cancel
Showing results for 
Search instead for 
Did you mean: 
sariahdog
4 - Data Explorer
4 - Data Explorer

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?
1 Reply 1
zazadi
5 - Automation Enthusiast
5 - Automation Enthusiast

I think you have only a problem with your syntax. Try this:

IF(
  AND(
    IS_SAME({Entered},TODAY(),'year'),
    IS_SAME({Entered},TODAY(),'month')
      ),
1,
0
  )