Identify Actual Date Data

[Johmz]

I need help creating workflow identifying if the data provided is actual Date if not consider as false information.  Thanks in advance

[cjaneczko]

Can you provide an example? Not sure what you  mean.

[aatalai]

@Johmz initial guess would be use the directory tool as that will provide information like file path, dates relating to creation (from memory) and that might have the information you would need.

But if not like @cjaneczko more information would help

[Johmz]

DATA	Is it Date
11/23/2023	11/23/2023
Brittany	False Information
New Yorl	False Information
01/07/2024	01/07/2024

[cjaneczko · Accepted solution]

Something like this will work in a formula tool.

if isnull(DateTimeParse([DATA],'%m/%d/%Y')) then 'False Information' else datetimeformat(DateTimeParse([DATA],'%m/%d/%Y'),'%m/%d/%Y') endif

[Johmz]

thanks for helping. This workflow will help me to complete my project. 

[Johmz]

Hi @cjaneczko 

I have changes to workflow that if the DATA is Actual Date the result should be True Data. I tried to changed the syntax but i not the actual result.. 

[cjaneczko]

So instead of the date showing you just want the it to say 'True Data' in text? Altering the formula to the below should do that.

if isnull(DateTimeParse([DATA],'%m/%d/%Y')) then 'False Information' else 'True Data' endif

[cjaneczko · Accepted solution]

Actually dont use the above. It can lead to false positives. Try the following in a formula tool instead.

IF regex_match([DATA],"[01]{0,1}\d\/[0-3]*\d\/20\d{2}") then 'True Date' else 'False Information' endif

[Johmz]

It's now working. Thanks for the help. much appreciated