topic Input box date validation in QlikView

Input box date validation

Anonymous — Wed, 21 Dec 2016 05:34:53 GMT

I have created an input box which accepts dates. i need to add validation so that the user is prompted to enter dates only in MM/DD/YYYY format. Is there a way to add such validations to the inputbox like EXcel? If he enters date in any other format it still needs to be accept it as MM/DD/YYYY format

Re: Input box date validation

avinashelite — Wed, 21 Dec 2016 05:38:30 GMT

validation part i am not sure ..but you can format the variable like

vinputdate is the variable then in your calculation try like

date(vinputdate ,'MM/DD/YYYY')

Re: Input box date validation

Anonymous — Wed, 21 Dec 2016 05:51:22 GMT

Why not use a calendar object to select the dates instead?

This way the input will always be in the correct input format and range.

Re: Input box date validation

Anonymous — Wed, 21 Dec 2016 09:17:10 GMT

if i use a calendar object and select the date it appears in the number format...how do i change this..when i tried converting it in number format its not working

=date(vInputDate,'MM/DD/YYYY')

Re: Input box date validation

Anonymous — Wed, 21 Dec 2016 09:20:45 GMT

Change the format under settings. Override document settings, select date and change to the format you require on the right to MM/DD/YYYY

Sent from my Samsung Galaxy smartphone.

Re: Input box date validation

Anonymous — Wed, 21 Dec 2016 09:45:54 GMT

thanks..its working now