https://community.qlik.com/t5/App-Development/Variable-Yesterday-at-21-00/m-p/2124371#M91498 <P>Hi,</P> <P>someone have some idea how can I create a variabile in the script that can extract the table's datas before the 21:00 about yesterday?<BR /><BR />example:<BR />today = 02/10/2023<BR />result variable = 01/10/2023 21:00:00</P> <P>&nbsp;</P> <P>regards,</P> <P>M.</P> Mon, 02 Oct 2023 15:38:28 GMT EMME_DR 2023-10-02T15:38:28Z https://community.qlik.com/t5/App-Development/Variable-Yesterday-at-21-00/m-p/2124371#M91498 <P>Hi,</P> <P>someone have some idea how can I create a variabile in the script that can extract the table's datas before the 21:00 about yesterday?<BR /><BR />example:<BR />today = 02/10/2023<BR />result variable = 01/10/2023 21:00:00</P> <P>&nbsp;</P> <P>regards,</P> <P>M.</P> Mon, 02 Oct 2023 15:38:28 GMT https://community.qlik.com/t5/App-Development/Variable-Yesterday-at-21-00/m-p/2124371#M91498 EMME_DR 2023-10-02T15:38:28Z https://community.qlik.com/t5/App-Development/Variable-Yesterday-at-21-00/m-p/2124373#M91499 <P>I think:</P> <P>LET vX = TimeStamp(Today(1)-1) + MakeTime(21))</P> <P>-Rob</P> Mon, 02 Oct 2023 15:41:04 GMT https://community.qlik.com/t5/App-Development/Variable-Yesterday-at-21-00/m-p/2124373#M91499 rwunderlich 2023-10-02T15:41:04Z