FYTD AND PFYTD

[henry2]

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

Too calculate the 365days before and after.

[abhijitnalekar]

Hi @henry2 ,

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]

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

[abhijitnalekar]

Hello @henry2 ,

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

Is this kind of thing you are looking.