Date Calculated Column in a Report

[MoniqueEvans]

I'm not sure why but whenever I try to do a calculated column my brain goes foggy. I want to simply add a column to my report that calculates 8 weeks before a custom date field called "E-Comm Due Date". Can someone please put me out of my misery and give me the value expression??

[Richard_Le_ · Accepted solution]

Hi Monique,

This should do it:

displayname=8 weeks before E-Comm Date

textmode=true

valueexpression=ADDDAYS({DE:E-Comm Due Date},-56)

valueformat=HTML

Best Regards,

Rich.

[MoniqueEvans]

THANK YOU SO MUCH RICHARD!!!!

I don't know if I ever would have thought about using -56. Works like a charm!

[AnishJ]

Hi Richard,

How do I calculate if I have to take a difference of entry date to the date a report is run?

For e.g. I'm trying to create a report for projects where the "Last updated date" is greater than 14 days when run.