nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

IF(AND Today not working correctly. Please help

Heath Sanders · 2017-09-11T00:41:21+00:00

=IF(AND([Last Contact Date]2 - TODAY() 120), "3-6 Mths")

Heath Sanders

=IF(AND([Last Contact Date]2 - TODAY() < 90, [Last Contact Date]2 - TODAY() > 120), "3-6 Mths")

Comments

Andrew Duval

Hi Heath,

it seems that you've flip-flopped the greater than and the less than signs in your formula. you'll want to swap the two and have >90 and <120.

Hope this helps.

Mike Wilday

Unless you are getting a specific error message, it appears like Andrew's suggestion is accurate.