topic Re: Find Abnormal date in Alteryx Server Discussions https://community.alteryx.com/t5/Alteryx-Server-Discussions/Find-Abnormal-date/m-p/1063320#M12498 <P>Maybe you ca try IsNull(ToDate([FieldName]))</P> Wed, 11 Jan 2023 11:47:31 GMT gabrielvilella 2023-01-11T11:47:31Z Find Abnormal date https://community.alteryx.com/t5/Alteryx-Server-Discussions/Find-Abnormal-date/m-p/1063226#M12496 <P>I want to filter and separate the data from one table to another which are related to the wrong formatted date.</P><P>&nbsp;</P><P>eg:- 45564</P><P>12/89/2021</P> Wed, 11 Jan 2023 09:19:32 GMT https://community.alteryx.com/t5/Alteryx-Server-Discussions/Find-Abnormal-date/m-p/1063226#M12496 Dharshika 2023-01-11T09:19:32Z Re: Find Abnormal date https://community.alteryx.com/t5/Alteryx-Server-Discussions/Find-Abnormal-date/m-p/1063320#M12498 <P>Maybe you ca try IsNull(ToDate([FieldName]))</P> Wed, 11 Jan 2023 11:47:31 GMT https://community.alteryx.com/t5/Alteryx-Server-Discussions/Find-Abnormal-date/m-p/1063320#M12498 gabrielvilella 2023-01-11T11:47:31Z