+1Hi Team,
I have tried to create Accuracy rule for Date datatype to check whether Date is in the standard format.
Accurate rule should be as follows:
When I tried using regex expression, I am getting error.
Any ideas?
Best answer by AKislyakov
Hi
I suggest you change type of the input attribute to String. If your data is already stored as Date datatype it means it is already valid date and format is enforced by the source.
Yet if you need to check Date type field, I suggest removing implicit type conversion using variables and rewrite expression using toString function.
matches(@"^(\d{1,2})-(\d{1,2})-(\d{4})$", toString(input_dt, "dd-MM-yyyy"))
Hi
I suggest you change type of the input attribute to String. If your data is already stored as Date datatype it means it is already valid date and format is enforced by the source.
Yet if you need to check Date type field, I suggest removing implicit type conversion using variables and rewrite expression using toString function.
matches(@"^(\d{1,2})-(\d{1,2})-(\d{4})$", toString(input_dt, "dd-MM-yyyy"))
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.