[From Wrike] Using the NOW() function to reference today ๐






Mobeen Tahir Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Mobeen Tahir Wrike Team member Become a Wrike expert with Wrike Discover
It looks like we don't have the translated page you're looking for, but we do have other content in English and offer support in English.
It looks like you're trying to figure something out.
Stuck or just want advice?
You can unlock the true value of Wrike in our Community
Connect with thousands of leading teams, learn best practices, and shape the future of the product. What are you waiting for?
Now other members can find, vote, and discuss your idea.
Our Community Team reads every suggestion (yes, every one) then compiles and shares the feedback with our Product Team. Happy posting!
More about Product FeedbackWhat can we help you with?
Learn. Share. Discuss.
Now other members can find, vote, and discuss your idea.
Our Community Team reads every suggestion (yes, every one) then compiles and shares the feedback with our Product Team. Happy posting!
More about Product FeedbackMobeen Tahir Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Mobeen Tahir Wrike Team member Become a Wrike expert with Wrike Discover
Folllowing List for Post: [From Wrike] Using the NOW() function to reference today ๐
[this list is visible for admins and agents only]
Hi Mobeen,
Thank you a lot for this useful article related to Analyze and NOW function! I have one questions if I may.
I wanted to see when was the last and only last change in any of the task within the project (to see the latest activeness). Is this possible? So far I created the below formula, but the numbers of days are really high and I think they might not capture only ONE, LAST change from all task status changes:
DDIFF (NOW ([Days in Task Status Change History Previous Change Date]),[Days in Task Status Change History Previous Change Date])
Kind regards,
Mateusz
Hello Mateusz Pawlak,
Thank you for your feedback and I am glad you found the article useful!
Your use case is quite interesting and a good use of the NOW function to calculate that. First thing I'd like to mention is, it would be better to use the field "Task Status Change History Change Date" instead of the field you used ""Task Status Change History Previous Change Date". The latter gives the date of a previous change and since we want to calculate the latest change, we should use the first field I mentioned. You can find more information on these fields here: Wrike Analyze - Available Data
To calculate the time difference between the the status change and the current time, you are on the correct path. The base formula you have is correct (by replacing the field as I mentioned above) and your use of NOW is set up correctly. But to make sure we only capture the latest change we would need to define that in the formula with the help of multi-pass aggregation. Your formula would look like this:
To explain, I am using the MIN function (minimum) to group all my status change dates and capturing only the smallest one. The smallest value should represent the latest status change that happened. If you are using a pivot table with task names as one of your columns of the table, this will automatically run one by one for each task and capture the minimum value of the date difference between NOWย andย Task Status Change History Change Date.
Please let me know if this formula works for you, or if you have any more questions.
Thank you.
ย
Mobeen Tahir Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Mobeen Tahir Wrike Team member Become a Wrike expert with Wrike Discover