Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Display if the field has a number

1026 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

I'm working with some data coming from another group and they use both text and dates in a fields that I need to pull apart and use the dates to estimate further due dates down the line. I'm trying to avoid the big #ERROR! when the field has text and not a date. Is there a way to pull out just dates into another field (or in the formula I'm already using) so it ignores the text? 

fields.jpg

Formula.jpg

3 Replies 3

In your "AND", try adding another criteria of `{EST} != "NO RIGHTS"` so that your "DATETIME_FORMAT" will only run on dates?

I considered that but unfortunately there's no consistency to what text will be used in that space and since this data comes from another team, I'm trying to find a work around without them having to change their process. Otherwise I think that would be a great solution! 

Ah I see!  In that case, what if we used an "IF" to check if the "DATETIME_FORMAT" function results in an error like so:

IF(
  NOT(
    ISERROR(
      DATETIME_FORMAT(Date,"YYYY")
    )
  ),
  DATETIME_FORMAT(Date,"YYYY")
)

Screenshot 2023-05-25 at 8.42.10 AM.png