Find Date Formet - Qlik Community

Report Inappropriate Content · ‎2015-05-07

Hi All,

Is there any function to find whether the data in the field are in date format or not

or any ways to find it .

Thanks,

jpenuliar · ‎2015-05-07

Hi,

There is a function you can use or copy from below:

CSV Data Integrity - Table Analyser

The Dates Tab(Script) checks for valid Date formats (alt())

PrashantSangle · ‎2015-05-07

Hi,

There is no specific function to identify date format.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-05-07

Thanks for the reply . But is there any way to find it inside the app itself...

jpenuliar · ‎2015-05-07

As max dreamer said, there is no qv function to check if field value is in date format.

I would suggest take the logic from Table Analyser file and create your own function within your qv app

jpenuliar · ‎2015-05-07

have a quick search in the community for previous threads:

Getting the date format