Custom fields type Date - Conditions related to date today

Hi there,

we use plenty of custom field regarding the validity of a certain document or license. in this case, we would like to have a conditional marker that contrast that date with today. This can be really helpfull to know when a certain document is not valid anymore.

(or even know if the document will not be valid in the next 30 days.

Find more posts tagged with

Comments

Juan Muttoni

Hello @Jose Gacitua, thank you for bringing your case to us. This can be achieved using a formula custom field, I'm attaching two screenshots to illustrate the steps you'd need to follow:

Please, let me know if you have any additional questions 🙂

Also, I'm moving your post to the "How to" section 👍

Jose Gacitua

Thanks Juan! this is a good approach.

just another fast question, do all the Date Fields turn red when the date is Past today? or only the "due date" from a task

Elizaveta Bogdanova

Hi @Jose Gacitua, I'm jumping in for Juan here.

It should be the due dates 👍

Raimund Dienst

Hi @Elizaveta Bogdanova,

is there any feature request to set a date turning red, if it is not the due date? I will install the workaround, but would be great to indicate the date red directly (and even yellow if approaching the date).

Rohan V

Hi, @Raimund Dienst 🙋‍♂️

I hope you don’t mind me jumping in for Lisa here. So far, there is no specific feedback post/request to have a date turn red when it isn’t the due date. Please feel free to create one in our Product Feedback forum. In the meantime, I hope the workaround suggested above in the comments will be beneficial. Do let us know if you have any other questions. Thank you!