Forum Discussion

MelanieProebste's avatar
Qrew Trainee
9 months ago

Formula Assistance - Comparing Two Dates

I need assistance with this formula. I am trying to formulate the following:

 - 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. 

CAT - Cats Complete Date is a date/time field
Monthly Period is a date field

If(LastDayOfMonth(ToDate([CAT - Cats Complete Date]))=LastDayOfMonth([Monthly Period]),

Melanie Proebstel

1 Reply

  • Your formula looks correct.  What is the problem?

    Mark Shnier (Your Quickbase Coach)