Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
james
Creator III
Creator III

Input Box Constraint for date only

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

1 Solution

Accepted Solutions
matt_crowther
Specialist
Specialist

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

View solution in original post

2 Replies
matt_crowther
Specialist
Specialist

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
Creator III
Creator III
Author

Nice, thats golden...

Thank you