topic Need data from Jan 2020 to till now in App Development

Need data from Jan 2020 to till now

Divya — Thu, 03 Feb 2022 04:44:22 GMT

Hi,

I need a data from 2020 Jan to now (today),then I created two variables,

Let vStartofdDateRange =num(date('01-01-2020','DD.MM.YYYY));

Let vEndofDateRange=num(today()-1);

How I will get data then

Re: Need data from Jan 2020 to till now

anat — Thu, 03 Feb 2022 07:50:47 GMT

Sum({$<datenum= {">=$(=num(date('01-01-2020','DD.MM.YYYY)))<=$(=num(today()-1))"}>} sal)

try something like above....

Re: Need data from Jan 2020 to till now

chris_djih — Thu, 03 Feb 2022 07:51:33 GMT

What you are looking for is called YearToDate or YTD.
Please have another search for this, since there are already existing many solutions and topics for this problem.