https://community.qlik.com/t5/QlikView/Capture-future-dates-2-days-from-today/m-p/1781758#M1209536 <P>Hi, I have a date field called SCHEDULED_FUTURE_DT, I want to create a calculated dimension for my table chart that pulls in all SCHEDULED_FUTURE_DT values that fall within 2 days from today.&nbsp; Please help! thank you!</P> Wed, 10 Feb 2021 19:55:55 GMT drohm002 2021-02-10T19:55:55Z https://community.qlik.com/t5/QlikView/Capture-future-dates-2-days-from-today/m-p/1781758#M1209536 <P>Hi, I have a date field called SCHEDULED_FUTURE_DT, I want to create a calculated dimension for my table chart that pulls in all SCHEDULED_FUTURE_DT values that fall within 2 days from today.&nbsp; Please help! thank you!</P> Wed, 10 Feb 2021 19:55:55 GMT https://community.qlik.com/t5/QlikView/Capture-future-dates-2-days-from-today/m-p/1781758#M1209536 drohm002 2021-02-10T19:55:55Z https://community.qlik.com/t5/QlikView/Capture-future-dates-2-days-from-today/m-p/1781799#M1209543 <P>you do not need a calculated dimension.&nbsp; you add the criteria in your expression and QlikView will pull the dates where the expressions are not 0 or null.<BR /><BR />try this:&nbsp; add SCHED_FUTURE_DT as dimension, and in your expression add the modifier:<BR /><BR />{&lt;SCHEDULED_FUTURE_DT={"&gt;=$(=today())&lt;=$(date(today()+2))"}&gt;}</P> Wed, 10 Feb 2021 23:05:12 GMT https://community.qlik.com/t5/QlikView/Capture-future-dates-2-days-from-today/m-p/1781799#M1209543 edwin 2021-02-10T23:05:12Z