Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula Assistance

Topic Labels: Formulas
Solved
Jump to Solution
973 2
cancel
Showing results for 
Search instead for 
Did you mean: 
krtphr
6 - Interface Innovator
6 - Interface Innovator

Hello all, I'm working with formulas, but got stuck on something. What I'm trying to accomplish here is simple, but not sure how to formulate it. I have a linking record for an invoice for NET Terms: NET15, 30 etc. 

I have the formula set up, but I want that converted into a date format rather than what I have. 

 

IF({TERM}="NET15", "15 Days from 'Due Date'",
 IF(
    {TERM}="NET30", "30 days from 'Due Date'"
    )
)

 

 Simple, but this is the output:

krtphr_0-1688936121009.png

Pretty simple, however I was testing the formula, and for invoice structure - I wanted a date format approach. So If NET15, then have the "Due Date" 15 days BASED off of the "Date" field. I don't know how I'd structure that, but that's the primary goal. Instead of showcasing "15 days from 'Due Date'", I'd rather it show a date format. 

EX: Date: 7/9/2023 Due Date: 7/24/2023 TERM: NET15

Any advice would be helpful! Thanks. 

1 Solution

Accepted Solutions
Harsh2
6 - Interface Innovator
6 - Interface Innovator

Hi @krtphr 

Try this formula

 

 

IF({TERM}="NET15", DATETIME_FORMAT(DATEADD({Date},-15,'days'),"MM/DD/YYYY")
,
 IF(
    {TERM}="NET30", DATETIME_FORMAT(DATEADD({Date},-30,'days'),"MM/DD/YYYY")
    )
)

 

See Solution in Thread

2 Replies 2
Harsh2
6 - Interface Innovator
6 - Interface Innovator

Hi @krtphr 

Try this formula

 

 

IF({TERM}="NET15", DATETIME_FORMAT(DATEADD({Date},-15,'days'),"MM/DD/YYYY")
,
 IF(
    {TERM}="NET30", DATETIME_FORMAT(DATEADD({Date},-30,'days'),"MM/DD/YYYY")
    )
)

 

krtphr
6 - Interface Innovator
6 - Interface Innovator

This works perfectly, thank you so much. I edited it to add, instead of subtract.