This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am trying to format a input box with a format like 'DD/MM/YYY'. Is there a way to restrict anything different from that?
I used a trigger to do this:
=If(Len(Trim(Date(Date#(vVar, 'DD/MM/YYYY')))) > 0, vVar, 'Incorrect Format')
View solution in original post
See if the attached file meets your requirement
what is the issue you are having? it would be better if you can share a sample in order to help you.
The only rare thing i see in your format is that you are using YYY instead of YYYY for year format.
I've tried an input box, in number tab selected date and DD/MM/YYYY and it worked fine!
Please let me know if this helps.
This is exactly what I'd like to do.
So, how do you configure 'Incorrect Format' message in Qlikview?
Sorry, I just type wrong the number of 'Y'. It should be YYYY instead.
I'll try this way and let you know!
Thank you very much Sunny!