dynamic in script - Qlik Community

soniasweety · ‎2020-09-17

hi all,

currently im writing the where condition in script static. but i want to do dynamic.

can someone help me with the condtion.

where date(Mydate)>='07/01/2020' and date(mydate)<='09/16/2020';

edwin · ‎2020-09-17

pls supply more info. where will the start and end dates come from? how were you thinking of controlling these in your script? will they come from a different table? or a variable?

Brett_Bleess · ‎2020-10-14

Did you try the following:

where date(MyDate)>='07/01/2020'<='09/16/2020';

Not sure if that will work or not, but I think that may be the correct syntax, but I am not certain.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.