Trouble with Start and End Dates

[hopkinsc]

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

[#2]

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]

Silly me!!

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

Thanks

[#4]

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]

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.

[#6]

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]

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]

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]

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

Does anyone know why?