[Integrity] - Report Computed Fields: Challenge #4

Hi Anita,

Using now() will always return the time when the report runs or when the calculated field displays.

Instead, you may need to construct the timestamp for the 1st of the month and pass that to historicFieldValue.

There is a function available which seems like it should handle this: "timestamp()".

timestamp() will accept a string in a particular format (such as "MMM d, yyyy HH:mm:ss") and turn that into a timestamp.

So what you would want to do is use now() and the getYear/getMonth type of functions to fill in the MMM and yyyy values in the string, but hardcode d as 1 (for first of the month) and HH:mm:ss as 00:00:00.

If this gets too complicated for a computed field, you could also make a new trigger which runs at midnight on the 1st of the month, checks if the item is open or closed, then records the 0 or 1 in a field.

Using a monthly trigger does have 1 gap, which is that if the item was created after the 1st of the current month, the field would be blank. You might set up a default value for the field or a trigger to auto-set that value when an item is created to solve that gap.

Hope that helps,

Matt