Current date in formula

Avatar
Pietro Poli

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 commentaires
Avatar
Pietro Poli

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 

3
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Barry Horne

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]

Haut de la page
Didn’t find what you were looking for? Write new post