Formula Assistance - Comparing Two Dates

Question

I need assistance with this formula. I am trying to formulate the following:&nbsp;- If the date in the CAT - Cats Complete Date field is in the same month and year as the date in the Monthly Period field, then return 1, otherwise return 0.&nbsp;
CAT - Cats Complete Date is a date/time fieldMonthly Period is a date field
If(LastDayOfMonth(ToDate([CAT - Cats Complete Date]))=LastDayOfMonth([Monthly Period]),1,0)------------------------------Melanie Proebstel------------------------------

markshnier__you · Answer

Your formula looks correct.&nbsp; What is the problem?
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Formula Assistance - Comparing Two Dates