Hi, I'm building a formula that says if the first payment date is equal to the month today then show the first payment date otherwise show other payments with the month today.
+22Hey @Yviana - I normally type a bunch, but I'm tired.
Try this formula:
IF(
{1st payment},
IF(
MONTH({1st payment}) = MONTH(TODAY()),
{1st payment}
),
IF(
{2nd payment},
IF(
MONTH({2nd payment}) = MONTH(TODAY()),
{2nd payment}
),
IF(
{3rd payment},
IF(
MONTH({3rd payment}) = MONTH(TODAY()),
{3rd payment}
),
IF(
{4th payment},
IF(
MONTH({4th payment}) = MONTH(TODAY()),
{4th payment}
)
)
)
)
)+22As a side note, your data is better suited if you create a separate table for payment records.
Each payment record has a due date that gets rolled up on the original table for easy reporting and it kills these four bloated date fields on your table.
It's clean, easy to scale, and would be along best practices when it comes to thinking about this in a database.
Happy to provide more details if you're curious.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.