I have an existing request report that shows the requests with their converted projects and I would like to bring in the last note from those projects. Currently it pulls from the requests.  Thanks for your help   

So I let it marinate over night and now it seems to be working! Very weird! Thanks for all your help!

Nope. Same. 

Yep. You can see it works for some and not for others. And some are blank with no numbers at all.

Thx Madalyn,  but that gives me the same results.

ACK!!Now I've got it working on some. For some I still get N/A and for others I'm getting negative numbers. All of our projects are set up exactly the same way, with the same fields. Any idea what could be happening?

Yes, that all makes sense now.  But I keep getting N/A in my calculated field.What might I be doing wrong?

I'm still confused. Apologies if my ask was confusing.  So am I able to create a column in my report that shows the number of days or do I need to create the calculated field in my custom form? I was hoping to put it as a column on my report.

Thank Rich.  So how would this work if I'm using a custom field? The built-in "planned completion date" is often different from our "Target/Live Due Date" ?  

Hi there! I'm trying to create a report to show any/all projects that come in with a turn-around time (target live/due date) that is under two weeks from entry date (request date). Is there a text mode filter out there that anyone has used? Thanks!