Inputbox with date formatting

[Anonymous]

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]

See if the attached file meets your requirement

[santiago_respane]

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]

Thank you!

This is exactly what I'd like to do.

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

[Anonymous]

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 · Accepted solution]

I used a trigger to do this:

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

[Anonymous]

Thank you very much Sunny!