Hi everybody,
I'm working on a dynamic workflow where from a data set that contain many dates, I need to remove the current and last month entries every time this process will run on a monthly basis.
I've been able to set up the workflow to filter the entries with data from the current month, however I've not been able to set anything to pull the date from "Current Month -1" let's say.
Any thoughts?
Thanks !
Solved! Go to Solution.
Hey there,
I attached a workflow that adds a conditional check. (You can edit the formula to return anything in the "MonthCheck" column).
Its using the DateTimeNow() formula to check the days date, then parsing that to only month and comparing that to "Field2" which is in a date format.
Let me know if this works, I know it's a little sloppy but it's Friday. : )
Why go through all that trouble?
Can't you simply calculate the number of months since say 1900 Jan 1 for both days. Difference between those two months count is the number of months between them.