Help

Leave Blank if #Error

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
859 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

I've tried this several times and nothing I do seems to work. I'm trying to wrap this formula in an IF(ISERROR( so that if there is an error it stays blank and I can't get it to work. I'm working with a formula field that sometimes displays text and sometimes a date. if it's a date, it should be used in the formula to give me the new date and if it's text, I just want the new field to remain blank. 

   IF(
   AND(
       {PAY2 TV From}="PAY1",
       {PAY1 Formula/Manual}
   ),
      DATETIME_FORMAT(DATEADD({PAY1 Formula/Manual},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"),

IF(
   AND(
      {LTR},
      {PAY2 TV From}="LTR"
   ),
   DATETIME_FORMAT(DATEADD({LTR},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"),
   ""
)
)

 error formula.jpg

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Need to determine if the output of the "PAY1 Formula/Manual" field is a date or a string

 

IF(
   AND(
      {PAY2 TV From}="PAY1",
      NOT(ISERROR(DATESTR(({PAY1 Formula/Manual})))
   ),
   DATETIME_FORMAT(DATEADD({PAY1 Formula/Manual},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"),
   IF(
      AND(
         {LTR},
         {PAY2 TV From}="LTR"
      ),
      DATETIME_FORMAT(DATEADD({LTR},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"),
      ""
   )
)

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Need to determine if the output of the "PAY1 Formula/Manual" field is a date or a string

 

IF(
   AND(
      {PAY2 TV From}="PAY1",
      NOT(ISERROR(DATESTR(({PAY1 Formula/Manual})))
   ),
   DATETIME_FORMAT(DATEADD({PAY1 Formula/Manual},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"),
   IF(
      AND(
         {LTR},
         {PAY2 TV From}="LTR"
      ),
      DATETIME_FORMAT(DATEADD({LTR},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"),
      ""
   )
)

 

Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Amazing that worked beautifully!!