I have the following requirement to be implemented using designer workflow.
- Custom List will have a column with value "Quarterly" or "Monthly"
- Based on the "Quarterly" or "Monthly" value, on the last day of that respective month, have to execute the following point (Point 3)
- Re-set the custom list's "Status" column value to "Initial" regardless of whatever value the item's "Status" column has.
I thought I would use the following
- Loop inside workflow
- Pause the workflow till a date
But I am not sure how to calculate last date within workflow.
I could create a calculated column and when the item is created or modified I can pick the value, but client doesn't want a calculated column in that list.