Null Date Check

[MarqueeCrew]

I've seen several posts and questions concerning NULL dates.  Is 09/31/2010 a valid date?  I know that 02/29/206 isn't valid and that 02/00/2006 isn't either, but I really don't like finding out about these in conversion warning messages.

I might suggest a function that returns True or False on the date check and let the user configure appropriate rules to rethink the attempted date prior to committing the field to the date data type.

Cheers,

Mark

[s_pichaipillai]

i wish to add this under Functions-->Test as "IsDate" Function, so it can used in Formula tool

[MarqueeCrew]

Thank you for the clarification.  Yes, this would be a new test function.

[Claje]

Having an "IsDate" function would be very helpful - currently i'm working on a demo for some of our business users, and having a baseline function would be fantastic.

[Kringstad]

Has anythng happened here? Would love to have these kind of functions IsNumber, IsDate, IsTrue +++

[Guruprem]

Any update from Alteryx R&D? Or Is there any alternative?

[TaraM]

The Data Profiling capability introduced in the Browse tool in 11.0 has made it easier to detect:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Data-Profiling-in-the-Browse-Tool-Alteryx-11...

The DateTime tool has also been updated with additional functionality in 11.0. While it doesn't address this ask specifically, the user experience has been improved. There is a video highlighting these features here: https://community.alteryx.com/t5/Engine-Works-Blog/11-Must-See-Feature-Videos-for-Alteryx-Analytics-...

Date Time tool features are highlighted in #4.

[Guruprem]

I found the solution as using Data convert tool and IsNull Filter.

My solution is inspired by :

https://community.alteryx.com/t5/Data-Preparation-Blending/Newbie-question-How-to-capture-values-tha...

[TaraM]

@Guruprem - That technique is even better!

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!