Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Trouble with Start and End Dates

Hi, i have tried putting start and end date calenders in my application but i can't get them to work.

Is it possible that someone could take a look at the sample i have attached to see what i'm doing wrong??

Any help would be greatly appreciated

Thanks

10 Replies
Not applicable

We can help you out only if you can tell us what exactly the issue is. Just attaching the application is not going to help us...

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Silly me!!

The issue is that when i enter both dates, it displays dates outside the range.

Thanks

Not applicable

Refer the application and do exactly what was done in the attached document! That will defiantly give solution for the problem that you are facing!

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi, thanks for your reply.

I have copied what you have done, i.e. the variables and the calender settings, but they still do not work. i'm lost...

I have attached the version with the changes i copied from your document.

Not applicable

Hi Hopkin,

I am not able to find it out what the problem you are facing. Could you please attach the screen shot for the same.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

here is a screen dump.

As you can see, i have entered a start date of 29th Aug 2010 and an end date of 31st Aug 2010 but the results are showing dates 28th Aug 2010.

Also i have noticed that after selecting dates, nothing appears in the current selections box, But on your example that you attached, the current selection boxes changes as soon as you select a date.

Could this be the problem?

Miguel_Angel_Baeyens

Hello,

It looks like a date formatting issue. Try creating a new TransDate field with function Date(), so your set analysis looks like

{< TransDate = {">=$(=Date(vStartDate))<=$(=Date(vEndDate))"} >}


Hope that helps

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Thanks Miguel, it looks like it was a formatting issue.

My date format was WWW DD-MMM-YYYY giving SAT 04-SEP-2010, i changed it to the default date format DD/MM/YYYY and it worked.

Thanks for your help.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

I still do not understand why the dates selected do not appear in my CURRENT SELECTIONS BOX?

Does anyone know why?