topic Input Box Constraint for date only in QlikView

Input Box Constraint for date only

james — Thu, 27 Jan 2011 17:55:36 GMT

Any idea to make the input box only accept date in this format MM/DD/YYYY?

Since the date are loaded that way, if someone inputs 1/05/11, it will not render any result where 01/05/2011 would

Any ideas? The help dialogue really doesn't help

matt_crowther — Thu, 27 Jan 2011 18:33:02 GMT

This is one that's trickier than it should be.

So far I've found the following:

In the input box add the 'Custom' Constraint: len($)=10

That forces all the MM/DD'YYYY values to be entered - it doesn't force it to be a valid date but should at least get around your stated issue.

I'll keep investigating as this should be possible.

Hope that helps,

Matt - Visual Analytics Ltd

james — Thu, 27 Jan 2011 18:48:01 GMT

Nice, thats golden...

Thank you