Hi,
I have a table where a datetime column is present with several records:
number datetimecolumn
1 2024-02-01 00:00:00
2 2024-02-02 00:00:00
I want a DQ Rule that filters out the datetime records that do not start with the first of the month. Meaning number 1 is valid, number 2 is invalid. I couldn't find anything useful in the condition builder option and the advanced expression (even through documentation in ONE expression) is giving me headache. Any suggestions how to fulfill this?
Best answer by AKislyakov
View original