Skip to main content
Question

Formula Assistance - Comparing Two Dates

  • September 7, 2023
  • 0 replies
  • 119 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

Your formula looks correct.  What is the problem?



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