Date Calculated Column in a Report | Community
Skip to main content
MoniqueEvans
Community Advisor
MoniqueEvansCommunity Advisor
Community Advisor
February 4, 2021
Solved

Date Calculated Column in a Report

  • February 4, 2021
  • 1 reply
  • 876 views

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??

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

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.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
February 5, 2021

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
    Community Advisor
    MoniqueEvansCommunity AdvisorAuthor
    Community Advisor
    February 6, 2021

    THANK YOU SO MUCH RICHARD!!!!

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

    Terms & ConditionsAccessibility statement

    Loading footer...