Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anselmo_meira
Creator II
Creator II

Inputbox with date formatting

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!

1 Solution

Accepted Solutions
sunny_talwar

I used a trigger to do this:


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


Capture.PNG


View solution in original post

6 Replies
sunny_talwar

See if the attached file meets your requirement

santiago_respane
Specialist
Specialist

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,

anselmo_meira
Creator II
Creator II
Author

Thank you!

This is exactly what I'd like to do.

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

anselmo_meira
Creator II
Creator II
Author

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

I used a trigger to do this:


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


Capture.PNG


View solution in original post

anselmo_meira
Creator II
Creator II
Author

Thank you very much Sunny!