FromDate and Todates fields are not Working

[sweety0912]

Hi,

Attached the Sample qvw. I created from date and todate in Calendar object to select the dates. But when i select from and todate data in table box is not responding to the date selections. I will be able to select from and todate and data should show based on the date selections. Please have a look at my sample qvw and reply me as soon as possible.

Thanks in advance!

[sweety0912]

Can anyone respond Please??

[m_woolf]

https://www.youtube.com/watch?v=UTDyO68BYL8&t=260s

[sweety0912]

I tried all this and it is not working in my scenario some how. I also attached my sample qvw. Could you please have a look and let me know what i am missing it.

[m_woolf]

You don't have triggers on your vStartDate and vEndDate variables.

[sweety0912]

Can you please reply me with the qvw? I am not able to achieve it some how. I really appreciate your help!

[Frank_Hartmann · Accepted solution]

see attached qvw

hope this helps

[sweety0912]

I have tried same thing that what you did in workflow but still if i select from and to date data is not showing based on selections.

[sweety0912]

I have used this formula Load *, Date#(SubField(Date1,' ',1),'M/D/YYYY') as Date;

After using the formula date is showing in number format so unable to select the From and todates. Attached the screenshot too.  Can you please have alook?

[m_woolf]

Try replacing Date# with Date.