This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
The formula as I have written it would look for any part of the field that has a date in the format you shared with us 01/01/2021. If the format would be different you would need to change the parameter to be looked at. As it is here, this would find dates that fit the pattern like in these cases: