topic Re: FYTD AND PFYTD in App Development

FYTD AND PFYTD

henry2 — Mon, 08 Nov 2021 21:35:40 GMT

How do I calculate a full year to date and pervious year to date.

Too calculate the 365days before and after.

abhijitnalekar — Tue, 09 Nov 2021 03:04:10 GMT

LYTD : ='>=' & Date(YearStart(Max(Date),-1), 'MM/DD/YYYY') & '<=' & Date(addyears(Max(Date),-1), 'MM/DD/YYYY')

CYTD : ='>=' & Date(YearStart(Max(Date)), 'MM/DD/YYYY') & '<=' & Date((Max(Date)), 'MM/DD/YYYY')

Hope this will help you.

henry2 — Tue, 09 Nov 2021 13:32:23 GMT

I WHAT THE FULL YEAR TO DATE FORMULA
AND PREVIOUS FULL YEAR TO DATE.

abhijitnalekar — Wed, 10 Nov 2021 03:29:09 GMT

Hello @henry2 ,

='>=' & date(now()-365,'DD-MM-YYYY') & '<=' & date(now()+365,'DD-MM-YYYY')

Is this kind of thing you are looking.