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 commenti
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]

Inizio

Prossime sessioni in diretta

Non hai trovato quello che cercavi? Scrivi un nuovo post