topic Re: Find Date Formet in QlikView

Find Date Formet

Thu, 07 May 2015 09:04:31 GMT

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 — Thu, 07 May 2015 09:13:13 GMT

Hi,

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

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

PrashantSangle — Thu, 07 May 2015 09:15:39 GMT

Hi,

There is no specific function to identify date format.

Regards

Thu, 07 May 2015 09:23:14 GMT

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

jpenuliar — Thu, 07 May 2015 09:32:43 GMT

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 — Thu, 07 May 2015 09:34:40 GMT

have a quick search in the community for previous threads: