+ Start a Discussion
Glenn Nyhan 91Glenn Nyhan 91 

Will This Formula Even Work?

I have an end user who is asking me to create a formula to do the following and I'm not even sure this is possible, so I'm asking for some input from the community if this formula can even be created

The formula she is requesting is this:

If Ground Break Photos Upload Date >/= -14 days from Ground Break Date then Ground Break Report Due = Ground Break Date -7 days. 

I've tried using the >= - 14  but I get an error message. I think it because of the Ground Break Photos Upload Date is a Date/Time field. So I'm not sure how to create a formula to handle that. 

Any help is greatly appreciated. 

Thanks,

Glenn
Best Answer chosen by Glenn Nyhan 91
SEKAR RAJ.SEKAR RAJ.
Hi Glenn,
1. Create a formula field and add the below condition.
IF((Ground Break Photos Upload Date >= Ground Break Date -14), Ground Break Date -7, null)

Thanks,
SEKAR RAJ

All Answers

SEKAR RAJ.SEKAR RAJ.
Hi Glenn,
1. Create a formula field and add the below condition.
IF((Ground Break Photos Upload Date >= Ground Break Date -14), Ground Break Date -7, null)

Thanks,
SEKAR RAJ
This was selected as the best answer
Glenn Nyhan 91Glenn Nyhan 91
Thanks, Sekar!