3 Replies Latest reply on May 23, 2016 5:20 AM by Stephane Marx

    Flag last day of the month

    david sharbaugh

      I have a detail file with a lot of dates in it (1/1/2016, 1/2/2016, etc...)  There is a field called Month to date which is keeping a cumulative record of a measure.  I want to show the monthly numbers and was going to do by showing the MTD value on the last day of the month.  I would like to put a calculated field that places a 1 in the field if the date is the last day of the month and a zero for all other days of the month and then I could filter on that.  Can someone help me with the syntax of the formula... or if there is a better way to do that, let me know.  Thanks