topic Re: Inputbox with date formatting in QlikView

Inputbox with date formatting

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

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?

Thank you!

sunny_talwar — Tue, 19 Jul 2016 14:08:00 GMT

See if the attached file meets your requirement

santiago_respane — Tue, 19 Jul 2016 14:11:29 GMT

Hi,

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.

Kind regards,

Anonymous — Tue, 19 Jul 2016 14:35:59 GMT

Thank you!

This is exactly what I'd like to do.

So, how do you configure 'Incorrect Format' message in Qlikview?

Anonymous — Tue, 19 Jul 2016 14:37:04 GMT

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.

sunny_talwar — Tue, 19 Jul 2016 14:42:12 GMT

I used a trigger to do this:

=If(Len(Trim(Date(Date#(vVar, 'DD/MM/YYYY')))) > 0, vVar, 'Incorrect Format')

Anonymous — Tue, 19 Jul 2016 14:53:10 GMT

Thank you very much Sunny!