Forum Discussion

MelanieProebste's avatar
MelanieProebste
Qrew Trainee
8 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]),
1,0)



------------------------------
Melanie Proebstel
------------------------------

1 Reply

  • Your formula looks correct.  What is the problem?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------