Data360 Analyze

Hello,

I am looking for a solution to search for future (or past) dates using wildcards.  

For example, something like, 

Expense_Date > 203*

or 

Expense_Date < 19*

My overall goal is to find outliers in the Expense_Date field that need to be reviewed.  So if I see an Expense_Date of 2048 or 2224, I can pull those out of the data and review them. 

Thanks!

Mike

Hi Mike,

Would it be as simple as using a Filter node to find records that have a date after some date you specify?

Ernest

Hello,

I am looking for a solution to search for future (or past) dates using wildcards.  

For example, something like, 

Expense_Date > 203*

or 

Expense_Date < 19*

My overall goal is to find outliers in the Expense_Date field that need to be reviewed.  So if I see an Expense_Date of 2048 or 2224, I can pull those out of the data and review them. 

Thanks!

Mike