Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 06, 2024 11:48 AM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 07, 2024 04:29 AM
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
)
Reply
