+9I'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?
+31In your "AND", try adding another criteria of `{EST} != "NO RIGHTS"` so that your "DATETIME_FORMAT" will only run on dates?
+9In 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!
+31I 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")
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.