Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

See if the attached file meets your requirement

Highlighted
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,

Highlighted
Creator II
Creator II

Thank you!

This is exactly what I'd like to do.

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

Highlighted
Creator II
Creator II

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.

Highlighted

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

Highlighted
Creator II
Creator II

Thank you very much Sunny!