topic how to validate date while entering in the input field. in QlikView

how to validate date while entering in the input field.

subin6600 — Tue, 08 May 2012 12:42:31 GMT

Hi Qlikwers!!

I have an input field which is like a write back functionality to the data base using macros and trigerring it with EDX.

But I want to make some error handlings like if the user enters the date I want it to be in the correct format.

For now the date format is YYYYMMDD. where i want the date & Month and 8 digits to be validated in the macro itself.

If any one have come across such a situation and knows the solution please let me know.

Thanks in advance.

Subin

Wed, 09 May 2012 20:49:08 GMT

I don't know if this helps, but you can somewhat control this by the input box itself.

You can right click the input box, properties->constraints->Click custom

then define it as something like

len($)=8 and mid($,5,2) <= '12' and mid($,7,2) <= 31

Then you can also check error message below and type in something like:

Please enter date in the format 'YYYYMMDD'

Now whenever the user enters in a date that does not follow your parameters this error message will pop up until they meet the correct requirements.

I will try making it in a macro next but figured this might fix your problem without the use of a macro.

Hope this helps!

-Brandon

subin6600 — Fri, 11 May 2012 09:17:53 GMT

Thanks Bapperson,

But how can i get the Properties> Constraints options??

I have a table in which one column is an input field which is mentioned in the script like inputfield xyz;

Fri, 17 Aug 2012 09:30:10 GMT

Hello,

does anyone got an idea for this question ? I have the same problem

Thanks

Sophie