Formula that Recognizes if DataTimeNow is Contained in Data

JacobGFMR

Hello,

If I have a field that contains a date, like 01/01/2020, but there is also other information in the field, like 01/01/2020 ABC, what formula can I write to obtain only data if the field contains a date, like DateTimeNow,

I am using the DataTimeNow and trying to find data with a current date, but occasionally the field has other information in it as well. 

I need to write a formula to recognize if the DateTimeNow is in that field. 

Thanks. 

TheOC

hey @JacobGFMR 

Many ways to do this!
By the sounds of things - the best way might be a find and replace tool.

What this allows you to do, is flag records where they contain something specifically. What i've done here is created two streams, one which has data similar to what you mentioned:

And another with a value of 1

I then use a formula to get the date now, and create that as a new field:

Then use find replace to Append the '1' to those records that contain the date field:

Then its a case of filtering where it contains the '1'.

A simpler approach, also attached to the workflow, is a 1 tool example using the filter tool:

You can actually filter on whether it contains specific text - within here you can specify datetimetoday as a string, so if it contains the date in the string, filter those out.

Both approaches are valid, and attached!

Hope this helps,
TheOC

JacobGFMR.yxmd