topic Year To Date Function in App Development

Year To Date Function

danimarc12 — Thu, 14 Jul 2022 14:33:16 GMT

Hello everyone!

I have an issue with the YTD expression. In my app the calendar I've created starts from the first date it finds data.

In this example, I have no data in my dataset before the 10th of January.

But if I use the YTD expression (date_field = {">=$(=Date(AddYears(Min([date_field]),-1)))<=$(=Date(AddYears(Max([date_field]),-1)))"})

my expression shows data starting from the 10th of January 2021 loosing the informations of the previous days.

I've tried to add the function YearStart() but if I select another range time it calculates data always starting from the first of Jan.

How can I solve this issue?

Thanks to all!

sidhiq91 — Thu, 14 Jul 2022 15:30:27 GMT

@danimarc12 will something like below expression help:

Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>}

Let me know if it does.

danimarc12 — Thu, 14 Jul 2022 15:51:05 GMT

Hi @sidhiq91 and thanks for your aswer.

As I said, if I use the YearStart() function, I can't compare different periods like March 2022 over March 2021.

rwunderlich — Thu, 14 Jul 2022 17:30:12 GMT

Add a MonthStart function.

Date(MonthStart(AddYears(Min([date_field]),-1)))