Current date in formula

Hi folk!

Do you know if is there any way to get Current Date (date of today) in Wrike Analyze and use it in formulas?

 

I'm creating something to show if project due date is exceeded.

IF([Days in Project Due Date]>Current date,Exceeded,Ok)

thanks in advance

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 Kommentare

I resolved!!!

😅

This is my formula 

IF(SUM(DDIFF([Days in Project Due Date],NOW([Days in Project Due Date])))<0,0,1)

If result is 0 project is exceeded, if 1 project is ok 

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

A great question and thank you for sharing your solution.  I am saving the formula :)

 

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Current date in formula
[this list is visible for admins and agents only]

Nach oben
Didn’t find what you were looking for? Write new post