Help

Formula Assistance

Topic Labels: Formulas
Solved
Jump to Solution
506 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.