I need to create a Task with a due date for the last day of the current month

Hi Robert McAnally,

PHP can handle the concept of "current month" rather well with custom code, but there is not much that comes to mind regarding how one would set a value to the last day of the current month in a date field using calculated fields or SugarBPM.

If the due date can afford to be the last possible moment of the month, a workaround that Sugar's user interface supports simply can be the first minute of the next month, which is comparable.

If it needs to be the last day of the month, and so the above does not work, a logic hook coded in PHP should be able to handle generating the date you need and populating the date accordingly. Here is a link to a discussion on this topic.

I hope this helps!

Hi Robert McAnally,

PHP can handle the concept of "current month" rather well with custom code, but there is not much that comes to mind regarding how one would set a value to the last day of the current month in a date field using calculated fields or SugarBPM.

If the due date can afford to be the last possible moment of the month, a workaround that Sugar's user interface supports simply can be the first minute of the next month, which is comparable.

If it needs to be the last day of the month, and so the above does not work, a logic hook coded in PHP should be able to handle generating the date you need and populating the date accordingly. Here is a link to a discussion on this topic.

I hope this helps!

Thanks, Patrick!

However, I think I am missing something in the 2nd paragraph:  I am trying to create a Process Definition where if Task Type = X, then Due Date = first minute of next month...all I see in Constants are Fixed Date and Time Span.  Am I missing something?